Hi Compshack,
I am facing a problem while loading data into a component, as one of the fields(COMMENTS) appears to be of LONG datatype. When I pass values for this field, it throws an error after submission of data stating "Cannot find value (91.32) ".
I tried trimming the data and even passing blank value for this field, but it still gave the error. But the error doesn't come when the field has been deselected from the template
Is there anything that needs to be done for passing data into a LONG field?
Please offer your valuable suggestions on this
Thanks,
Danny
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Not that I know off. I know there is a problem with long fields and that is ExcelToCI only takes the first 1024 characters and no more. There is a fix for that but it doesn't sound like this is the issue you are having. It should be something with the way you are building your template.
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
I too had an issue with the long field. I finally just used ExcelToCI without the field and went back and updated the values via SQL script (created by reading the data keys and comment in an sqr program to create the SQL Script) after the load.
I know - why have a SQR create a SQL script rather than just do the insert within the SQR ... Because getting a sqr to the production database and creating all the online objects to execute it are not worth the effort. Instead I can run the SQR in a non production environment by giving the SQR the name of another that already exists with online objects and no run parameters required. I execute the sqr and pass the SQL script it created to the DBA for an update.
Lepa - you mention there is a fix for this? Could you share that?
Thanks
I don't have a fix for the original problem but do have one for the 1024 character issue. I can post it here when I get to my work PC tomorrow if that's what you want.
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Is it solved yet?
Ru using SQLExec in PC to update the data? If so, please take a look at PeopleBooks on %TextIn.
While creating ExceltoCI for acadmeic institution table I had entered value for Description say Indian Institute of Technology corresponding to Institution IIT , on submitting data it is saying value not found.
for description field there r neither transalts values nor prompt table
While creating ExceltoCI for acadmeic institution table I had entered value for Description say Indian Institute of Technology corresponding to Institution IIT , on submitting data it is saying value not found
was the issue resolved?
what was the solution?
Please the provide steps to over come excel to ci long descr field issue