"Process definitions could not be loaded" after server restart
I have PAM 7.1.1 on EAP 7.1.0 on Windows Server 2016 and connected to SQL Server 2016. Was able to deploy processes, start instances and saw the data persisted in my SQL Server DB.
After the server restart, I cannot see the process definitions, nor its instances and getting "Process definitions could not be loaded" error message.
The log on server startup shows: "Error when initializing server extension of type jBPM KIE Server extension: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmRequestList" Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '0x2e69'.
Also getting: ERROR [org.dashbuilder.exception.ExceptionManager] (default task-21) Can't lookup on specified data set: jbpmProcessInstances: org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: jbpmProcessInstances
If I remove all DB tables in the database and then restart the server - it again works and I can see the processes, create instances, etc.
Could someone please point me in the right direction?
Responses