ARSDOC UPDATE

[yousuf_gani]

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

[jsquizz]

Any hits in the system log for this?

[yousuf_gani]

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..

[jsquizz]

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.

[Justin Derrick]

And to answer the question about the extra query in the System Log - you may have searched across a segment (aka database table).

-JD.

[yousuf_gani]

Hi,
Sorry still the same Error even with enclosed with Single Quote for INTEGER value. and Nothing from the System Log.

Similar Command Used
arsdoc 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.

[jsquizz]

I did mine on 8.5.0.6

Send the EXACT syntax you used, just replace your CMOD object names and fields with XXXX

[yousuf_gani]

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.

[jsquizz]

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.

[yousuf_gani]

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

[jsquizz]

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.

[yousuf_gani]

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...

[Ed_Arnold]

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

[yousuf_gani]

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

[Greg Ira]

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.