Hi,
Have 1 Problem with 1 of our Older version of Ondemand 8.5.0.7.
Problem is while Arsdoc Update of multiple records, we get the search Successful but the update failed with below Message
command used :
arsdoc update -h <hostinstance> -u <username> -n "client_no = <NEW INTEGER Number>" -i "/*Updates X rows*/where client_no = <OLD INTEGER Number>" -f "<FOLDER NAME>" -G "<APPL GROUP NAME>" -v
Outout from arsdoc update
10/21/17 13:11:01 : Querying database with SQL string '/*Updates X rows*/where client_no = <OLD INTEGER NUMBER>'
10/21/17 13:11:01 : Search successful
10/21/17 13:11:01 : Updating X documents with
client_no=<NEW INTEGER NUMBER>
10/21/17 13:11:01 : Update unsuccessful
10/21/17 13:11:01 : Information has been modified on the server. Please logoff, logon, and retry the operation.
10/21/17 13:11:01 : arsdoc completed.
I found from the thread this error was fixed from 8.4.1.8, but we get this Error in our Version 8.5.0.7.
I even checked the USER permission and APPL_group permission have UPDATE access and FIELD to be UPDATABLE
Could you please help to solve this issue or any patch required to be Applied or any problem with our Command framed?
Thanks & regards
Any hits in the system log for this?
Hi,
No Error from the System log.
I just see LOGIN - ARSDOC, APPL GROUP QUERY and LOGOFF messages (Why 4 Query is I have "3 APPL group" reference in the FOLDER) and the UPDATE command is specific to 1 APPL_GROUP
Info 30 Login: localhost 127.0.0.1 non-SSL (Solaris) (ARSDOC) (8.5.0.7)
Info 65 Application Group Query: Name
Info 65 Application Group Query: Name
Info 65 Application Group Query: Name
Info 65 Application Group Query: Name
Info 32 Logoff
Any help will be so kind please.
thanks for the support..
You need ' ' around your integers..
arsdoc update -h archive -n "FIELD = '12345678'" -i "where FIELD = '87654321'" -f "FOLDER" -G "TESTAG" -v
10/26/17 12:34:59 : Starting arsdoc. Version: 8.5.0.6
10/26/17 12:34:59 : /usr/lpp/ars/bin/arsdoc update -h archive -n "FIELD = '12345678'" -i "where POLNO = '87654321'" -f "FOLDER" -G "TESTAG" -v
10/26/17 12:34:59 : Attempting login for userid 'admin' on server 'archive' ...
10/26/17 12:34:59 : Login successful
10/26/17 12:34:59 : Searching for folder 'FOLDER' ...
10/26/17 12:34:59 : Search successful
10/26/17 12:34:59 : Searching for documents in 'FOLDER' ...
10/26/17 12:34:59 : Querying database with SQL string 'where FIELD = '87654321''
10/26/17 12:34:59 : Search successful
10/26/17 12:34:59 : Updating 1 documents with
FIELD=12345678
10/26/17 12:34:59 : Update successful
10/26/17 12:34:59 : arsdoc completed.
And to answer the question about the extra query in the System Log - you may have searched across a segment (aka database table).
-JD.
Hi,
Sorry still the same Error even with enclosed with Single Quote for INTEGER value. and Nothing from the System Log.
Similar Command Usedarsdoc update -h <host instance> -u <username> -n "client_no = '12345'" -i "/*Updates X rows*/where client_no = '54321'" -f "<FOLDER NAME>" -G "<APPL GROUP NAME>" -v
Its Any bug with our Version of 8.5.0.7 as it works fine in your 8.5.0.6 and my other version 9.5.0.7 but not in 8.5.0.7
Any Suggestion will help,, or do i need to raise a PMR to IBM
Please help and suggest.
I did mine on 8.5.0.6
Send the EXACT syntax you used, just replace your CMOD object names and fields with XXXX
hi
Please find the Command triggered and Complete output
arsdoc update -h XXXX -u XXXX -p XXXX -G "XXXXXX" -f "XXXXXX" -v -n "XXXXX='12345'" -i "where XXXXX='54321'"
10/27/17 15:09:13 : Starting arsdoc. Version: 8.5.0.7
10/27/17 15:09:13 : arsdoc update -h XXXX -u XXXX -G XXXXXX -f XXXXXX -v -n XXXXX='12345' -i where XXXXX='54321'
10/27/17 15:09:13 : Attempting login for userid 'XXXX' on server 'XXXX' ...
10/27/17 15:09:13 : Login successful
10/27/17 15:09:13 : Searching for folder 'XXXXXX' ...
10/27/17 15:09:13 : Search successful
10/27/17 15:09:13 : Searching for documents in 'XXXXXX' ...
10/27/17 15:09:13 : Querying database with SQL string 'where XXXXX='54321''
10/27/17 15:09:13 : Search successful
10/27/17 15:09:13 : Updating 26 documents with
XXXXX=12345
10/27/17 15:09:13 : Update unsuccessful
10/27/17 15:09:13 : Information has been modified on the server. Please logoff, logon, and retry the operation.
10/27/17 15:09:13 : arsdoc completed.
Only thing I can think of, is you might have your -n / -i reversed.
Or a security issue with the user acconut you are using, but youve mentioned that youve tried that.
For sample to show hear I replaced the Actual number as 12345 / 54321.
Actually not able to identify the problem as the SEARCH is successful with "-i" search Criteria and it is Listed with the records during the "arsdoc Query" and "arsdoc update". But while Updating with "-n" is not success
10/27/17 15:09:13 : Search successful
10/27/17 15:09:13 : Updating 26 documents with
XXXXX=12345
10/27/17 15:09:13 : Update unsuccessful
This looks like a permission issue. I tried this on my administrator account and I got the same error message you got. I went and double checked security, and sure enough I had to make a change.
Hi,
That is the first thing I checked.
Field is Updateable
User -> Type is "SYstem Adminstrator" + has "Administrator and Access" Authority for that APPL group + has the Document "Update Access"
ANother Acces to Check from the Admin COnsole.?
Please suggest thanks a lot...
You're probably already done this but can you try some other userids who should have the proper authority?
I know, a long shot, but it's the only thing I can think of trying.
Ed
Hi Arnold,
When said about "Proper Authority", what else I require to check . Could you please help.
As the Same User could able to update for Other APPL_GROUP, but this specific APPL_GROUP retrun Failed during Update.
So Checked the below Permission
:> Field is Updateable
:> User -> Type is "SYstem Adminstrator" + has "Administrator and Access" Authority for that APPL group + has the Document "Update Access"
Any other Permission to be checked?
Thanks
Just to note. Anytime I've ever received the message "Information has been modified on the server. Please logoff, logon, and retry the operation." The issue has been traced to a DB error. Either someone changed something manually or some system table data got corrupted.
Quote from: yousuf_gani on October 31, 2017, 09:38:33 AM
Any other Permission to be checked?
I'm out of ideas.
Do you have a date when you plan to upgrade that system?
Ed
Quote from: yousuf_gani on October 31, 2017, 09:38:33 AM
Hi Arnold,
When said about "Proper Authority", what else I require to check . Could you please help.
As the Same User could able to update for Other APPL_GROUP, but this specific APPL_GROUP retrun Failed during Update.
So Checked the below Permission
:> Field is Updateable
:> User -> Type is "SYstem Adminstrator" + has "Administrator and Access" Authority for that APPL group + has the Document "Update Access"
Any other Permission to be checked?
Thanks
can you try doing this via your CMOD admin user, the one that does arsload/arsmaint/etc
Yes I tried using that default User "ADMIN" even , as this ADMIN user doesn't have the UPDATE access to the Document it failed.
I wil try to change the Permission only for the APPL_GROUP and let you know the result.
Sometimes you can receive strange messages when you try updates.
I would suggest that you create a COPY of the Folder you are using. In the copied folder, remove all other Application Groups.
Then try the update command using the copied folder instead.
This procedure has helped me out at least once.