Question
TEK
IN
Last activity: 24 Jan 2023 10:09 EST
trying to store an empty property ID to a database column that does not accept nulls: code: SQLState: Message:
In UI while insert the Record by using activity to push the record to data table . i have below erroe.
trying to store an empty property ID to a database column that does not accept nulls: code: SQLState: Message:
i have attach the below screenshots.
***Edited by Moderator Marije to change type from Pega Academy to Product***
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Accepted Solution
Updated: 24 Jan 2023 6:16 EST
TEK
IN
@SrinidhiM thanks for your reply. i fix the error. and i have another doubt can u tell me any logic for auto GenerateID ..
Pegasystems Inc.
IN
@NagaRajan M Can you please check if the value for the ID (key of Database) column is set properly?
TEK
IN
@SrinidhiM THANKS for your replay .yes its set properly
TEK
IN
@SrinidhiM Thanks for your reply . yes set properly.
Pegasystems Inc.
IN
@NagaRajan M Can you please share the values of property that are set on the ubdatapage and keys of your table
TEK
IN
@SrinidhiM i attach the below screenshot .Thanks
TEK
IN
@SrinidhiMThanks for your reply. i have attache the screen shot below. sry i am just learning pega if i am worng correct me pls. Thanks.
Pegasystems Inc.
IN
@NagaRajan M Can you also share the screenshot of Primary Page?
Accepted Solution
Updated: 24 Jan 2023 6:16 EST
TEK
IN
@SrinidhiM thanks for your reply. i fix the error. and i have another doubt can u tell me any logic for auto GenerateID ..
Pegasystems Inc.
IN
@NagaRajan M Hi You can use any of the functions from below:
@GenerateID("ID")
@pxGetUniqueID(tools)
@CreateUniqueID()
TEK
IN
@SrinidhiM I try this first logic and i have some .i attech the screenshot below. Thanks
Pegasystems Inc.
IN
@NagaRajan M The Property that you are using for the ID is Decimal/Number so it is not accepting the alphanumberic character. You can try out any one of below two options:
1. Change the ID property to String or
2. Use the @CreateUniqueID() function
TEK
IN
@SrinidhiM YES I use the second logic its working. but ID number is coming like this 46834664.i attach the screenshot below .but i want the numbers should be ID-1,ID-2.
Updated: 10 Jan 2023 7:53 EST
Pegasystems Inc.
GB
@NagaRajan M please check the available documentation:
https://support.pega.com/question/batch-new-case-id-generation
Generate sequential Unique ID for property without any prefix
Increase performance for work ID generation (8.3)
Work Unique ID (pyLastReservedID) getting increased abruptly post upgrade to Pega 8.3
Sequence of case IDs generated is incorrect
The latest documentation about this setting can be found in Default dynamic system settings
Also as the original question about the Database column population was fixed, could you please provide details on how you fixed it and mark this question with Accept Solution?
-
Srinidhi Mrithyunjayan
Updated: 10 Jan 2023 7:56 EST
Pegasystems Inc.
IN
@NagaRajan M Then you might need to change the ID property to Text , that will resolve your requirement. Also, please check the links provided @MarijeSchillern that is according to your requirements
TEK
IN
@SrinidhiM ok Thanks.
TEK
IN
Pegasystems Inc.
IN
@NagaRajan M Hi,
1. Obj-open-by-handle using the key of the record you wish to update (Fetch the key based on the requirement - for e.g if you are editing from table layout in UI record by record, your Key should be available in the row Primary)
2. set the updated properties
3. obj-save with write now (please use ootb activities like Save-Page to commit instead of methods)
These are the steps to be included in the activity, Please check Savable data pages instead of activity
Savable Datapages: Savable Datapage
TEK
IN
@SrinidhiMThanks for your reply.let me try .
TEK
IN
@SrinidhiM hi
help me for this.
how to change the case id format. if u have screen shot share me pls
Updated: 18 Jan 2023 4:33 EST
Pegasystems Inc.
IN
@nagar16730416 Hi Can you please explain your requirement? Change the format to what ?
TEK
IN
@SrinidhiM i fix that thanks
TEK
IN
@SrinidhiM hi
i have some external datas in my data page and i create a one section there i have some propertys ex( if i give the value in first name property and click the search button releated to first name all data have to display in section) below i have attach the screen shot . Thanks
Pegasystems Inc.
GB
@NagaRajan M if you need further help could I suggest that you log a new question with the relevant summary in the title so that you have a wider audience who can jump in and help out?
The original question was resolved according to your post on the 9th January.