arsdoc update issue

[giuseppe]

I'm trying to update 2 rows with arsdoc update. I'm using the ONDTNT usrprf that is the admin profile.
 
The arsdoc query works fine

arsdoc query -f Fatture -h QUSROND -u ONDTNT -p "/QIBM/UserData/OnDemand/ONDTNT/ars.stash" -H                         
   -i "WHERE codcli='93187'"                                                                                           
      -N "(nfatt)(dataf)(codcli)(piva)(ragsoc)(fil)(ente)(imponibile)(totale)(tipo)(nrtag)(nrord)"                                                                                                                                           
00686957,18/03/2022,93187   ,02669521201     ,CHIAVETTE UNIFICATE SPA                 ,009,   ,0,000000,226,700000,FBD 
00687214,21/03/2022,93187   ,02669521201     ,CHIAVETTE UNIFICATE SPA                 ,009,   ,0,000000,829,060000,FBD


but the update fails and says the the user is not authorized:

arsdoc update -h QUSROND -u ONDTNT -p "/QIBM/UserData/OnDemand/ONDTNT/ars.stash" 
           -f Fatture -i "WHERE codcli='93187'" -n "CODCLI=00093187" -v         

2022-03-21 18:08:34.646560: ARS6063I Ricerca dei documenti in 'Fatture' in corso...                   
2022-03-21 18:08:34.646792: ARS6117I Interrogazione del database con stringa SQL 'WHERE codcli='93187''
2022-03-21 18:08:34.878976: ARS6084I Ricerca eseguita correttamente                                   
2022-03-21 18:08:34.879504: ARS6068I Aggiornamento di 2 documenti con                                 
CODCLI=00093187                                                                                       
2022-03-21 18:08:35.073136: ARS6089E Aggiornamento non eseguito                                       
2022-03-21 18:08:35.073488: ARS2111E L'utente non è autorizzato a eseguire questa operazione

I've also tried with QUSROND but it says that the user/pass is not valid:

arsdoc update -h QUSROND -u QUSROND -p  xxxxxxxxxxxx                         
                 -f Fatture -i "WHERE codcli='93187'" -n "CODCLI=00093187" -v
                                                                             
2022-03-22 09:35:28.330712: ARS6108I Avvio di arsdoc.  Versione:  10.5.0.1   
2022-03-22 09:35:28.335744: ARS6822I Tentativo di collegamento per l'ID utente 'QUSROND' sul server 'QUSROND
2022-03-22 09:35:28.344904: ARS6081E Collegamento non eseguito                                             
2022-03-22 09:35:28.345360: ARS2107E ID utente o password non validi per il server          

Is there a way (apart from a direct sql update on table) to make this update ?

Thanks.
Giuseppe.                 
                           

[Stephen McNulty]

Giuseppe

look in the application group, field Information tab, and confirm that the field that you are trying to change has "updateable" selected.

The other way would be to use the windows client and update the field (but this would still require it to be 'updateable'

[giuseppe]

Hi Stephen

fields are updatable
we tried with my personal user and it worked.
then I've seen that someone removed app/perm from the ONDTNT admin profile.

Giuseppe.