Skip to main content
Kofax

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

Summary 

5090

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.

Keywords: qrtz