Hi,
I have below Record Type(s) structure.
Now when I try to load the column(s) data in the summary page from the RecordType "D", it is not loading. But, when I ran the "Data Sync" for the recordType "D" manually then I was able to see the data in the
summary page.
FYI: RecordType "B" is having a foreignkey relation ship with column data which is there in the RecordType "B".
Any tips please. Thanks in advanse.
Discussion posts and replies are publicly visible
You say "But, when I ran the "Data Sync" for the recordType "D" manually then I was able to see the data".
Does this mean you had no data before, then loaded data to DB and did not see that data in the record?
Can you please explain, in a timeline, what you are doing?
When the user entered the data using user Input screen/page, it got saved into the database.
Afterwords, user is try to see the data in the Summary page, but it is not reflected there. When I ran the "Data Sync" manually for the RecordType "D" then only it is stated showing up.
Again when the user submitted a new data, and if they go to Summary page, newly entered data is not reflecting.
Please let me know if you need any additional details. Thanks.
Which smart service do you use to write to DB? The Query DB node does NOT trigger a sync.
Is this a matter of time? Does waiting a minute bring the data up? Could it be a chaining issue?
I am using "Write to Data Store Entity" and "Write to Multiple Data Store Entities" along with script task.
No. It is not a matter of time. Data is not reflecting until I go and ran the "Data Sync".
The issue is with only RecordType "D". Whereas other RecordTypes data is reflecting properly.
Do you see any error messages? Is the sync status green? Did you check the tomcat-stdout log?
I did not see any issues
OK, but there is no chaining. Which means I expect the user to still see the old data immediately after completing the related action. Data should come up after a refresh.
Does the record sync status show any issues? What about the tomcat-stdout log?
Sync status was showing green whenever I manually ran.
Also, I have updated my process model with "Enable Activity Chaining". But, still no luck.
If the issue is only happening with record type D, what happens if you simplify your process and just have a Write to Data Store Entity node that only updates record type D? Do you then see your record type updated? That can help us identify if this is an issue with the record type or with the configuration of your process model.
I don't have issues with any of the RecordTypes and the only variation with RecordType "D" compare to other RecordTypes is, the Entity which is storing the data to "B" itself is storing the data to "D". Because, One of the column in "B" is having a Foreign Key relation and an Array to "D".
Can you explain what you mean with "Entity which is storing the data to "B" itself is storing the data to "D". Because, One of the column in "B" is having a Foreign Key relation and an Array to "D"."
Peter Lewis Quick question: The update trigger to a record when writing to DB is based on the table name as defined in the XSD?
Hi Stefan,
Please find the below attached details. Let me know if you need more details for more clarity.
Thanks