#335: reduce DataBuilder dependencies to i2b2 platform: ant, JVM, JDBC, jboss
--------------------------+------------------------
Reporter: dconnolly | Owner:
Type: enhancement | Status: closed
Priority: major | Milestone: gpc2sites
Component: data-sharing | Resolution: fixed
Keywords: | Blocked By:
Blocking: |
--------------------------+------------------------
Comment (by gkowalski):
Well ran it on our dev server after adding columns to the
qt_query_instance .
{{{
CTSI-iMac-gkowalski:seine-minibuilder-0.5-f08eb078cb97 gkowalsk$
./run_mcw.sh
Buildfile: /Users/gkowalsk/Projects/seine-
minibuilder-0.5-f08eb078cb97/build.xml
builder-job.queue-from-timeline:
[echo]
[echo] Building
/var/folders/9f/lmmxyx7d1838n46rhj762s6d5tfklq/T/null1708192621.sql from
input.xml...
[echo]
sql-script.run:
[echo]
[echo] running as FH_CDWDEMODATA_DEV in
jdbc:oracle:thin:@fhoradev.ctsi.mcw.edu:1521:cdwdev1 ...
[echo]
[sql] Executing resource:
/var/folders/9f/lmmxyx7d1838n46rhj762s6d5tfklq/T/null1708192621.sql
[sql] Failed to execute: insert into qt_query_instance (user_id,
group_id, patient_set, start_date, status_type_id, message) values
('mcwcorp\gkowalsk', 'CDW', 17819, current_timestamp, 1, -- queued
[sql]
'/var/folders/9f/lmmxyx7d1838n46rhj762s6d5tfklq/T/null1708192621<|>noMRN<|>noContact<|>TODO:
real label [PATIENT SET #17819]')
BUILD FAILED
/Users/gkowalsk/Projects/seine-minibuilder-0.5-f08eb078cb97/build-tasks
/builder-job.xml:115: The following error occurred while executing this
line:
/Users/gkowalsk/Projects/seine-minibuilder-0.5-f08eb078cb97/build-tasks
/sql-script.xml:46: java.sql.SQLIntegrityConstraintViolationException:
ORA-01400: cannot insert NULL into
("FH_CDWDEMODATA_DEV"."QT_QUERY_INSTANCE"."QUERY_INSTANCE_ID")
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1916)
at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878)
at
oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:773)
at
org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:743)
at
org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:1053)
at
org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:983)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:651)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:435)
at org.apache.tools.ant.Target.performTasks(Target.java:456)
at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
at
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:440)
at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:435)
at org.apache.tools.ant.Target.performTasks(Target.java:456)
at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
at org.apache.tools.ant.Project.executeTarget(Project.java:1364)
at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
at org.apache.tools.ant.Main.runBuild(Main.java:851)
at org.apache.tools.ant.Main.startAnt(Main.java:235)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
Total time: 0 seconds
CTSI-iMac-gkowalski:seine-minibuilder-0.5-f08eb078cb97 gkowalsk$
}}}
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/335#comment:29>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
