After migrating from a previous release of xFlow to xFlow 17.3 RU3, users are no longer able to log in, and logging is showing errors during the login attempts.
incidentMS.log:
ERROR - 2021-02-08 16:18:31 [c.ca.casm.framework.util.CasmFuture] - Exception occurred, see call stack for more details: userid ()
java.util.concurrent.CompletionException: com.ca.casm.exception.CasmBaseException: Error : NO, AHD04199:An unexpected Database error occurred. Contact your administrator., 32632|domsrvr|_PjAAA
at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:331)
at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:346)
at java.base/java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:870)
at java.base/java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:837)
at java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
Caused by: com.ca.casm.exception.CasmBaseException: Error : NO, AHD04199:An unexpected Database error occurred. Contact your administrator., 32632|domsrvr|_PjAAA
at com.ca.casm.actor.SdmCreateObjectActor.recvmsg1(SdmCreateObjectActor.java:775)
at com.ca.casm.actor.MdcActor$1.apply(MdcActor.java:213)
at akka.actor.ActorCell$$anonfun$become$1.applyOrElse(ActorCell.scala:606)
at akka.actor.Actor.aroundReceive(Actor.scala:517)
at akka.actor.Actor.aroundReceive$(Actor.scala:515)
stdlog:
02/08 16:18:31.79 servername sqlagt:Audit_Log eve 29584 ERROR orclclass.c 1313 SQL Statement Failed. ORA: 1722 Message: ORA-01722: invalid number
02/08 16:18:31.79 servername sqlagt:Audit_Log eve 29584 ERROR orclclass.c 1314 Clause (INSERT INTO casm_active_sessions ( access_key, access_token, cabi_sso_token, cat_domain_id, cat_domain_name, cat_login_domain, cat_parent_id, cat_role_id, contact_uuid, creation_dt, last_access_time, role_id, secret_key, tenant, id ) VALUES ( :val1 , :val2 , :val3 , :val4 , :val5 , :val6 , :val7 , :val8 , :val9 , :val10 , :val11 , :val12 , :val13 , :val14 , :val15 )) Input (<access_key:int>1981714516|<access_token:string>4681fc63018705dd878e0bfd71318bca011d90078dfc5fafa23db186c1fdd3c096b72a5efa620fb357beaefba2c63944d8e5966a3625e16c1d31add002b237bc|<cabi_sso_token:string>(NULL)|<cat_domain_id:string>Domain|<cat_domain_name:string>Domain|<cat_login_domain:string>Domain|<cat_parent_id:int>10001|<cat_role_id:string>spadministrator|<contact_uuid:uuid>F4C2A60100EA154695D233F90ABFFD21|<creation_dt:time>02/08/2021 16:18:31|<last_access_time:time>02/08/2021 16:18:31|<role_id:int>10002|<secret_key:string>(NULL)|<tenant:uuid>9E9D61E4647C01F5BB96001A4A20017B|<id:int>435853)
02/08 16:18:31.79 servername bpvirtdb_srvr 29567 ERROR vdbmisc.c 688 Miscellaneous Database error occured :ORA-01722: invalid number
The cat_domain_id field is supposed to be NVARCHAR2 in the casm_active_sessions table, but somehow it was as NUMBER.
See below the casm_active_sessions from an OOTB environment:
CA Service Management 17.3
Oracle database
Engage the DBA team and change the field cat_domain_id to NVARCHAR2 manually.
IMPORTANT:
It is a workaround to fix the issue and allow end-users to log into XFlow again. The environment has to be review to make sure there is no side-effect or similar issue regarding other fields with different formats. If noticing similar issues, consider reinstalling the environment from scratch. Probably there will be other unexpected issues or behavior impacting end-users.