topic Re: End point create error in Qlik Replicate

End point create error

SaranyaK — Thu, 06 Jan 2022 04:41:36 GMT

I am trying to create a new end point for Oracle and I am getting the below error

SYS-E-DESERIALERR, Failed to deserialize json to type TestDatabaseAsyncReq: SYS-E-OBJMODIF, The provided object has been modified on the server or the session have expired. Please repeat the change..
SYS,DESERIALIZE_TO_TYPE,TestDatabaseAsyncReq,SYS-E-OBJMODIF, The provided object has been modified on the server or the session have expired. Please repeat the change.

Can you please help on what the issue could be here?

Re: End point create error

john_wang — Thu, 06 Jan 2022 05:19:00 GMT

Hello @SaranyaK ,

Not sure if it's a random error or persisting one. If it's random, please force refresh the GUI Console page, or close/re-open the GUI Console (or even restart the 2 services: Server and Console services) and try again.

If it persists please upload "repsrv.log" - take note if the log file contains sensitive information, do not upload it here because it's public to all visitors, please open support cases.

Hope this helps.

Regards,

John.

Re: End point create error

SaranyaK — Thu, 06 Jan 2022 05:21:27 GMT

Thank you John!! Where can i find the repsrv.log?

Re: End point create error

SaranyaK — Thu, 06 Jan 2022 05:24:45 GMT

This is the error after force refresh/restart services. Please advise.
SYS-E-HTTPFAIL, Failed to load dynamic endpoint properties..
SYS,GENERAL_EXCEPTION,Failed to load dynamic endpoint properties.,Failed to decrypt connect item 'securityDbEncryption' Failed to decrypt data, the cipher text is corrupted

Re: End point create error

john_wang — Thu, 06 Jan 2022 05:25:32 GMT

Hi @SaranyaK ,

It's under <Replicate_DATA_Folder>/logs.

for example on Windows the default location is "C:\Program Files\Attunity\Replicate\data\logs". On Linux it's under "/opt/attunity/replicate/data/logs".

Regards,

John.

Re: End point create error

john_wang — Thu, 06 Jan 2022 05:35:24 GMT

Hi @SaranyaK ,

Did the endpoint ever work for you ? what's the Replicate version? What's the Oracle server version and client version? is it a 64-bit version... let me know more.

Regarding the error:

SYS,GENERAL_EXCEPTION,Failed to load dynamic endpoint properties.,Failed to decrypt connect item 'securityDbEncryption' Failed to decrypt data, the cipher text is corrupted

Please try re-typing in the password for this Oracle endpoint and the "Secret store encryption entries" values and test again.

BTW, it's better you work with DBA to make sure the "sqlplus" works on the Replicate Server. If it works then Replicate should work too.

Regards,

John.

Re: End point create error

SaranyaK — Thu, 06 Jan 2022 20:59:44 GMT

Thank you so much John, it appears there was a secret store encryption value set and after clearing it, it works. Thanks.

Re: End point create error

john_wang — Thu, 06 Jan 2022 22:29:57 GMT

Glad to hear that, Good Luck, @SaranyaK