Cannot analyze probabilistic sensitivity when added more than 2 expanded tables

Hi! I am using TreeAge Pro to run a cost-utility analysis for cancer survivors (based on different treatments at the starting point and different side effects) and would like to perform a probabilistic sensitivity analysis using the expanded table for sensitivity analysis.

The problem is that when I added 1 or 2 expanded tables, the analysis worked, but when I added 3 or more expanded tables, the analysis could not be performed, and I received the message below

An internal error occurred during:  "Saving analysis results...".
org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE DistributionsVariCol (iteration INT primary key, DIST_[*]-16 DOUBLE, DIST_-15 DOUBLE, DIST_-14 DOUBLE, DIST_-13 DOUBLE, DIST_-12 DOUBLE, DIST_-11 DOUBLE, DIST_-10 DOUBLE, DIST_-9 DOUBLE, DIST_-8 DOUBLE, DIST_-7 DOUBLE, DIST_-6 DOUBLE, DIST_-5 DOUBLE, DIST_-4 DOUBLE, DIST_-3 DOUBLE, DIST_-2 DOUBLE, DIST_-1 DOUBLE, DIST_0 DOUBLE, DIST_1 DOUBLE)"; expected "IDENTITY, BIGSERIAL, SERIAL, data type"; SQL statement:
CREATE TABLE DistributionsVariCol (iteration INT primary key, DIST_-16 DOUBLE, DIST_-15 DOUBLE, DIST_-14 DOUBLE, DIST_-13 DOUBLE, DIST_-12 DOUBLE, DIST_-11 DOUBLE, DIST_-10 DOUBLE, DIST_-9 DOUBLE, DIST_-8 DOUBLE, DIST_-7 DOUBLE, DIST_-6 DOUBLE, DIST_-5 DOUBLE, DIST_-4 DOUBLE, DIST_-3 DOUBLE, DIST_-2 DOUBLE, DIST_-1 DOUBLE, DIST_0 DOUBLE, DIST_1 DOUBLE) [42001-210]

What could be the cause of this, and how can I resolve this issue?
Thank you.

0

Comments

1 comment
  • You may want to contact support via support@treeage.com for this issue as it will require review of the model. Please provide your serial number with the support request.

    Andrew

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post