MarkView Advisor - analytics-core.ear file fails to deploy correctly.

Applies To

• ERP System: Oracle, SAP
• MarkView Version: MarkView 9.0 and Below
• Application Server: WebLogic

Behavior

• The analytics-core.ear file fails to deploy correctly. When viewing the Application Server log files you may see errors similar to the following:

java.sql.SQLException: error in script file line: 48 bad TEXT table source file - line number: 6069 bad TEXT table source file - line number: $$ $$: ja

ERROR com.corda.server - Problem starting notifications scheduler
org.quartz.JobPersistenceException: Couldn't store trigger 'Notifications Check trigger' for 'Notifications Master Check' job:Unique constraint violati
E_ZONE_ID) VALUES(?, ?, ?, ?)] [See nested exception: java.sql.SQLException: Unique constraint violation: in statement [INSERT INTO qrtz_CRON_TRIGGERS
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1247)

Known Causes

• In some situations the qrtz_triggers.txt file can become corrupted and will need to be rebuilt.

Resolution

To resolve the issue please take these steps:

1. Backup the current analytics-core.ear file
   1. Logon to the WebLogic Console -> Deployments
   2. Click on the analytics-core deployment
   3. Under the Overview tab note the Path of the analytics-core.ear file.
   4. Backup the analytics-core.ear file from the "Path" directory by copying it to a new directory.
2. Stop MarkView Server(s) on WebLogic
3. Open the following folder “<Dashboard_Install-Dir>/dashboard/Server/config/adminfiles”
4. Find file “qrtz_triggers.txt”, make a backup and remove it completely
5. Find file "qrtz_fired_triggers.txt", make a backup and remove it completely
6. Find file "qrtz_cron_triggers.txt" make a backup and remove it completely
7. Open deployments in WebLogic and delete “analytics-core-ear” (using Delete button in WebLogic Admin Console)
8. Install “analytics-core-ear” deployment again (using Install button in WebLogic Admin Console)
9. Start MarkView server(s) on WebLogic

Once the system is started up again those files will be rebuilt automatically.

Note: The analytics-core.ear file is environment specific. You cannot copy this ear file from one environment to another.