SETTURGOPI Posted July 24, 2018 Share Posted July 24, 2018 Hi we are using the below combinationjasperreports-server-cp-7.1.0-bin on apache-tomcat-8.0.52with Oracle database. we have started with clean database instance and executed all mysql scrips with minor issues how ever we are unable to start the applciation Error starting at line : 1 in command -ALTER TABLE JIListOfValuesItem MODIFY COLUMN value longblob NULLError report -SQL Error: ORA-00905: missing keyword00905. 00000 - "missing keyword"*Cause: *Action:Error starting at line : 4 in command -ALTER TABLE JIReportJob ADD COLUMN scheduledResource bigint NOT NULL DEFAULT 0Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:table TEMP_JOB_TO_RESOURCE created.0 rows updated.table TEMP_JOB_TO_RESOURCE dropped.Error starting at line : 38 in command -DELETE f FROM JIReportJobOutputFormat f INNER JOIN JIReportJob j ON f.report_job_id = j.id WHERE j.scheduledResource = 0Error at Command Line : 38 Column : 10Error report -SQL Error: ORA-00933: SQL command not properly ended00933. 00000 - "SQL command not properly ended"*Cause: *Action:Error starting at line : 39 in command -DELETE p FROM JIReportJobParameter p INNER JOIN JIReportJob j ON p.job_id = j.id WHERE j.scheduledResource = 0Error at Command Line : 39 Column : 10Error report -SQL Error: ORA-00933: SQL command not properly ended00933. 00000 - "SQL command not properly ended"*Cause: *Action:0 rows deleted.Error starting at line : 42 in command -ALTER TABLE JIReportJob ADD CREATE INDEX FK156F5F6AFF0F459F ON JIReportJob (scheduledResource), ADD CONSTRAINT FK156F5F6AFF0F459F FOREIGN KEY (scheduledResource) REFERENCES JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 49 in command -DROP INDEX uri_index ON JIObjectPermissionError report -SQL Error: ORA-00933: SQL command not properly ended00933. 00000 - "SQL command not properly ended"*Cause: *Action:Error starting at line : 50 in command -ALTER TABLE JIObjectPermission MODIFY COLUMN uri varchar(1000) NOT NULLError report -SQL Error: ORA-00905: missing keyword00905. 00000 - "missing keyword"*Cause: *Action:Error starting at line : 52 in command -CREATE INDEX uri_index ON JIObjectPermission (uri(255))Error at Command Line : 52 Column : 47Error report -SQL Error: ORA-00904: "URI": invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:=======================================================Error starting at line : 1 in command -ALTER TABLE JIListOfValuesItem MODIFY COLUMN value longblob NULLError report -SQL Error: ORA-00905: missing keyword00905. 00000 - "missing keyword"*Cause: *Action:Error starting at line : 4 in command -ALTER TABLE JIReportJob ADD COLUMN scheduledResource bigint NOT NULL DEFAULT 0Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:table TEMP_JOB_TO_RESOURCE created.0 rows updated.table TEMP_JOB_TO_RESOURCE dropped.Error starting at line : 38 in command -DELETE f FROM JIReportJobOutputFormat f INNER JOIN JIReportJob j ON f.report_job_id = j.id WHERE j.scheduledResource = 0Error at Command Line : 38 Column : 10Error report -SQL Error: ORA-00933: SQL command not properly ended00933. 00000 - "SQL command not properly ended"*Cause: *Action:Error starting at line : 39 in command -DELETE p FROM JIReportJobParameter p INNER JOIN JIReportJob j ON p.job_id = j.id WHERE j.scheduledResource = 0Error at Command Line : 39 Column : 10Error report -SQL Error: ORA-00933: SQL command not properly ended00933. 00000 - "SQL command not properly ended"*Cause: *Action:0 rows deleted.Error starting at line : 42 in command -ALTER TABLE JIReportJob ADD CREATE INDEX FK156F5F6AFF0F459F ON JIReportJob (scheduledResource), ADD CONSTRAINT FK156F5F6AFF0F459F FOREIGN KEY (scheduledResource) REFERENCES JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 49 in command -DROP INDEX uri_index ON JIObjectPermissionError report -SQL Error: ORA-00933: SQL command not properly ended00933. 00000 - "SQL command not properly ended"*Cause: *Action:Error starting at line : 50 in command -ALTER TABLE JIObjectPermission MODIFY COLUMN uri varchar(1000) NOT NULLError report -SQL Error: ORA-00905: missing keyword00905. 00000 - "missing keyword"*Cause: *Action:Error starting at line : 52 in command -CREATE INDEX uri_index ON JIObjectPermission (uri(255))Error at Command Line : 52 Column : 47Error report -SQL Error: ORA-00904: "URI": invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:==================================================== 2018-07-23 13:20:52,848 ERROR JDBCExceptionReporter,localhost-startStop-1:101 - ORA-00904: "REPOPROFIL0_"."OWNER": invalid identifier2018-07-23 13:20:52,875 ERROR ContextLoader,localhost-startStop-1:331 - Context initialization failedorg.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select repoprofil0_.id as id12_, repoprofil0_.attrName as attrName12_, repoprofil0_.attrValue as attrValue12_, repoprofil0_.description as descript4_12_, repoprofil0_.owner as owner12_, repoprofil0_.principalobjectclass as principa6_12_, repoprofil0_.principalobjectid as principa7_12_ from JIProfileAttribute repoprofil0_ where repoprofil0_.principalobjectclass=? and repoprofil0_.principalobjectid=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query Error starting at line : 677 in command -alter table JIAccessEvent add create index FK47FB3CD732282198 on JIAccessEvent (user_id), add constraint FK47FB3CD732282198 foreign key (user_id) references JIUser (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 683 in command -alter table JIAccessEvent add create index FK47FB3CD7F254B53E on JIAccessEvent (resource_id), add constraint FK47FB3CD7F254B53E foreign key (resource_id) references JIResource (id) on delete cascadeError report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 690 in command -alter table JIAwsDatasource add create index FK6085542387E4472B on JIAwsDatasource (id), add constraint FK6085542387E4472B foreign key (id) references JIJdbcDatasource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 696 in command -alter table JIAzureSqlDatasource add create index FKAFE22203C001BAEA on JIAzureSqlDatasource (keyStore_id), add constraint FKAFE22203C001BAEA foreign key (keyStore_id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 702 in command -alter table JIAzureSqlDatasource add create index FKAFE2220387E4472B on JIAzureSqlDatasource (id), add constraint FKAFE2220387E4472B foreign key (id) references JIJdbcDatasource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 708 in command -alter table JIBeanDatasource add create index FK674BF34A8BF376D on JIBeanDatasource (id), add constraint FK674BF34A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 714 in command -alter table JIContentResource add create index FKE466FC68A8BF376D on JIContentResource (id), add constraint FKE466FC68A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 720 in command -alter table JICustomDatasource add create index FK2BBCEDF5A8BF376D on JICustomDatasource (id), add constraint FK2BBCEDF5A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 726 in command -alter table JICustomDatasourceProperty add create index FKB8A66AEA858A89D1 on JICustomDatasourceProperty (ds_id), add constraint FKB8A66AEA858A89D1 foreign key (ds_id) references JICustomDatasource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 732 in command -alter table JICustomDatasourceResource add create index FKDF845123858A89D1 on JICustomDatasourceResource (ds_id), add constraint FKDF845123858A89D1 foreign key (ds_id) references JICustomDatasource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 738 in command -alter table JICustomDatasourceResource add create index FKDF845123F254B53E on JICustomDatasourceResource (resource_id), add constraint FKDF845123F254B53E foreign key (resource_id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 744 in command -alter table JIDataSnapshotParameter add create index id_fk_idx on JIDataSnapshotParameter (id), add constraint id_fk_idx foreign key (id) references JIDataSnapshot (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 750 in command -alter table JIDataType add create index FK533BCC63A8BF376D on JIDataType (id), add constraint FK533BCC63A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 756 in command -alter table JIFTPInfoProperties add create index FK6BD68B04D5FA3F0A on JIFTPInfoProperties (repodest_id), add constraint FK6BD68B04D5FA3F0A foreign key (repodest_id) references JIReportJobRepoDest (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 762 in command -alter table JIFileResource add create index FKF75B5889A8BF376D on JIFileResource (id), add constraint FKF75B5889A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 768 in command -alter table JIFileResource add create index FKF75B58895A0C539 on JIFileResource (reference), add constraint FKF75B58895A0C539 foreign key (reference) references JIFileResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 774 in command -alter table JIInputControl add create index FKCAC6A512120E06F7 on JIInputControl (data_type), add constraint FKCAC6A512120E06F7 foreign key (data_type) references JIDataType (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 780 in command -alter table JIInputControl add create index FKCAC6A512A8BF376D on JIInputControl (id), add constraint FKCAC6A512A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 786 in command -alter table JIInputControl add create index FKCAC6A51262A86F04 on JIInputControl (list_of_values), add constraint FKCAC6A51262A86F04 foreign key (list_of_values) references JIListOfValues (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 792 in command -alter table JIInputControl add create index FKCAC6A512B37DB6EB on JIInputControl (list_query), add constraint FKCAC6A512B37DB6EB foreign key (list_query) references JIQuery (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 798 in command -alter table JIInputControlQueryColumn add create index FKE436A5CCE7922149 on JIInputControlQueryColumn (input_control_id), add constraint FKE436A5CCE7922149 foreign key (input_control_id) references JIInputControl (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 804 in command -alter table JIJNDIJdbcDatasource add create index FK7F9DA248A8BF376D on JIJNDIJdbcDatasource (id), add constraint FK7F9DA248A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 810 in command -alter table JIJdbcDatasource add create index FKC8BDFCBFA8BF376D on JIJdbcDatasource (id), add constraint FKC8BDFCBFA8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 816 in command -alter table JIListOfValues add create index FK4E86A776A8BF376D on JIListOfValues (id), add constraint FK4E86A776A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 822 in command -alter table JIListOfValuesItem add create index FKD37CEBA993F0E1F6 on JIListOfValuesItem (id), add constraint FKD37CEBA993F0E1F6 foreign key (id) references JIListOfValues (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 828 in command -alter table JILogEvent add create index FK5F32081591865AF on JILogEvent (userId), add constraint FK5F32081591865AF foreign key (userId) references JIUser (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 834 in command -alter table JIMondrianConnection add create index FK4FF53B191D51BFAD on JIMondrianConnection (id), add constraint FK4FF53B191D51BFAD foreign key (id) references JIOlapClientConnection (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 840 in command -alter table JIMondrianConnection add create index FK4FF53B19324CFECB on JIMondrianConnection (reportDataSource), add constraint FK4FF53B19324CFECB foreign key (reportDataSource) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 846 in command -alter table JIMondrianConnection add create index FK4FF53B19C495A60B on JIMondrianConnection (mondrianSchema), add constraint FK4FF53B19C495A60B foreign key (mondrianSchema) references JIFileResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 852 in command -alter table JIMondrianXMLADefinition add create index FK313B2AB8A8BF376D on JIMondrianXMLADefinition (id), add constraint FK313B2AB8A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 858 in command -alter table JIMondrianXMLADefinition add create index FK313B2AB8DC098B1 on JIMondrianXMLADefinition (mondrianConnection), add constraint FK313B2AB8DC098B1 foreign key (mondrianConnection) references JIMondrianConnection (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 864 in command -alter table JIOlapClientConnection add create index FK3CA3B7D4A8BF376D on JIOlapClientConnection (id), add constraint FK3CA3B7D4A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 870 in command -alter table JIOlapUnit add create index FKF034DCCFA8BF376D on JIOlapUnit (id), add constraint FKF034DCCFA8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 876 in command -alter table JIOlapUnit add create index FKF034DCCF8F542247 on JIOlapUnit (olapClientConnection), add constraint FKF034DCCF8F542247 foreign key (olapClientConnection) references JIOlapClientConnection (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 882 in command -alter table JIQuery add create index FKCBCB0EC9A8BF376D on JIQuery (id), add constraint FKCBCB0EC9A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 888 in command -alter table JIQuery add create index FKCBCB0EC92B329A97 on JIQuery (dataSource), add constraint FKCBCB0EC92B329A97 foreign key (dataSource) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 894 in command -alter table JIReportAlertToAddress add create index FKC4E3713022FA4CBA on JIReportAlertToAddress (alert_id), add constraint FKC4E3713022FA4CBA foreign key (alert_id) references JIReportJobAlert (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 900 in command -alter table JIReportJob add create index FK156F5F6AE4D73E35 on JIReportJob (mail_notification), add constraint FK156F5F6AE4D73E35 foreign key (mail_notification) references JIReportJobMail (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 906 in command -alter table JIReportJob add create index FK156F5F6AC83ABB38 on JIReportJob (alert), add constraint FK156F5F6AC83ABB38 foreign key (alert) references JIReportJobAlert (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 912 in command -alter table JIReportJob add create index FK156F5F6A9EEC902C on JIReportJob (content_destination), add constraint FK156F5F6A9EEC902C foreign key (content_destination) references JIReportJobRepoDest (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 918 in command -alter table JIReportJob add create index FK156F5F6A74D2696E on JIReportJob (job_trigger), add constraint FK156F5F6A74D2696E foreign key (job_trigger) references JIReportJobTrigger (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 924 in command -alter table JIReportJob add create index FK156F5F6AFF0F459F on JIReportJob (scheduledResource), add constraint FK156F5F6AFF0F459F foreign key (scheduledResource) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 930 in command -alter table JIReportJob add create index FK156F5F6A4141263C on JIReportJob (owner), add constraint FK156F5F6A4141263C foreign key (owner) references JIUser (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 936 in command -alter table JIReportJobCalendarTrigger add create index FKC374C7D0D2B2EB53 on JIReportJobCalendarTrigger (id), add constraint FKC374C7D0D2B2EB53 foreign key (id) references JIReportJobTrigger (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 942 in command -alter table JIReportJobMailRecipient add create index FKBB6DB6D880001AAE on JIReportJobMailRecipient (destination_id), add constraint FKBB6DB6D880001AAE foreign key (destination_id) references JIReportJobMail (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 948 in command -alter table JIReportJobOutputFormat add create index FKB42A5CE2C3389A8 on JIReportJobOutputFormat (report_job_id), add constraint FKB42A5CE2C3389A8 foreign key (report_job_id) references JIReportJob (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 954 in command -alter table JIReportJobParameter add create index FKEAC52B5F2EC643D on JIReportJobParameter (job_id), add constraint FKEAC52B5F2EC643D foreign key (job_id) references JIReportJob (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 960 in command -alter table JIReportJobRepoDest add create index FKEA477EBE3C5B87D0 on JIReportJobRepoDest (ssh_private_key), add constraint FKEA477EBE3C5B87D0 foreign key (ssh_private_key) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 966 in command -alter table JIReportJobSimpleTrigger add create index FKB9337C5CD2B2EB53 on JIReportJobSimpleTrigger (id), add constraint FKB9337C5CD2B2EB53 foreign key (id) references JIReportJobTrigger (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 972 in command -alter table JIReportThumbnail add create index FKFDB3DED932282198 on JIReportThumbnail (user_id), add constraint FKFDB3DED932282198 foreign key (user_id) references JIUser (id) on delete cascadeError report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 979 in command -alter table JIReportThumbnail add create index FKFDB3DED9F254B53E on JIReportThumbnail (resource_id), add constraint FKFDB3DED9F254B53E foreign key (resource_id) references JIResource (id) on delete cascadeError report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 986 in command -alter table JIReportUnit add create index FK98818B77A8BF376D on JIReportUnit (id), add constraint FK98818B77A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 992 in command -alter table JIReportUnit add create index FK98818B778FDA11CC on JIReportUnit (query), add constraint FK98818B778FDA11CC foreign key (query) references JIQuery (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 998 in command -alter table JIReportUnit add create index FK98818B77324CFECB on JIReportUnit (reportDataSource), add constraint FK98818B77324CFECB foreign key (reportDataSource) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,004 in command -alter table JIReportUnit add create index FK98818B778C8DF21B on JIReportUnit (mainReport), add constraint FK98818B778C8DF21B foreign key (mainReport) references JIFileResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,010 in command -alter table JIReportUnitInputControl add create index FK5FBE934AE7922149 on JIReportUnitInputControl (input_control_id), add constraint FK5FBE934AE7922149 foreign key (input_control_id) references JIInputControl (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,016 in command -alter table JIReportUnitInputControl add create index FK5FBE934AA6A48880 on JIReportUnitInputControl (report_unit_id), add constraint FK5FBE934AA6A48880 foreign key (report_unit_id) references JIReportUnit (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,022 in command -alter table JIReportUnitResource add create index FK8B1C4CA5A6A48880 on JIReportUnitResource (report_unit_id), add constraint FK8B1C4CA5A6A48880 foreign key (report_unit_id) references JIReportUnit (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,028 in command -alter table JIReportUnitResource add create index FK8B1C4CA5865B10DA on JIReportUnitResource (resource_id), add constraint FK8B1C4CA5865B10DA foreign key (resource_id) references JIFileResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,034 in command -alter table JIRepositoryCache add create index FKE7338B19E7C5A6 on JIRepositoryCache (item_reference), add constraint FKE7338B19E7C5A6 foreign key (item_reference) references JIRepositoryCache (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:index RESOURCE_TYPE_INDEX created.Error starting at line : 1,042 in command -alter table JIResource add create index FKD444826DA58002DF on JIResource (childrenFolder), add constraint FKD444826DA58002DF foreign key (childrenFolder) references JIResourceFolder (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,048 in command -alter table JIResource add create index FKD444826DA08E2155 on JIResource (parent_folder), add constraint FKD444826DA08E2155 foreign key (parent_folder) references JIResourceFolder (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,054 in command -alter table JIResourceFolder add create index FK7F24453BA08E2155 on JIResourceFolder (parent_folder), add constraint FK7F24453BA08E2155 foreign key (parent_folder) references JIResourceFolder (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,060 in command -alter table JIRole add create index FK82724655E415AC2D on JIRole (tenantId), add constraint FK82724655E415AC2D foreign key (tenantId) references JITenant (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,066 in command -alter table JITenant add create index FKB1D7B2C97803CC2D on JITenant (parentId), add constraint FKB1D7B2C97803CC2D foreign key (parentId) references JITenant (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,072 in command -alter table JIUser add create index FK8273B1AAE415AC2D on JIUser (tenantId), add constraint FK8273B1AAE415AC2D foreign key (tenantId) references JITenant (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,078 in command -alter table JIUserRole add create index FKD8B5C1403C31045 on JIUserRole (roleId), add constraint FKD8B5C1403C31045 foreign key (roleId) references JIRole (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,084 in command -alter table JIUserRole add create index FKD8B5C14091865AF on JIUserRole (userId), add constraint FKD8B5C14091865AF foreign key (userId) references JIUser (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,090 in command -alter table JIVirtualDataSourceUriMap add create index FK4A6CCE019E600E20 on JIVirtualDataSourceUriMap (virtualDS_id), add constraint FK4A6CCE019E600E20 foreign key (virtualDS_id) references JIVirtualDatasource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,096 in command -alter table JIVirtualDataSourceUriMap add create index FK4A6CCE01F254B53E on JIVirtualDataSourceUriMap (resource_id), add constraint FK4A6CCE01F254B53E foreign key (resource_id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,102 in command -alter table JIVirtualDatasource add create index FK30E55631A8BF376D on JIVirtualDatasource (id), add constraint FK30E55631A8BF376D foreign key (id) references JIResource (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:Error starting at line : 1,108 in command -alter table JIXMLAConnection add create index FK94C688A71D51BFAD on JIXMLAConnection (id), add constraint FK94C688A71D51BFAD foreign key (id) references JIOlapClientConnection (id)Error report -SQL Error: ORA-00904: : invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action:index JILOGEVENT_USERID_INDEX created.index JIREPORTJOB_ALERT_INDEX created.index IDX25_CONTENT_DESTINATION_IDX created.index JIREPORTJOB_JOB_TRIGGER_INDEX created.index IDX26_MAIL_NOTIFICATION_IDX created.index JIREPORTJOB_OWNER_INDEX created.index IDX24_ALERT_ID_IDX created.index IDX27_DESTINATION_ID_IDX created.index IDX14_REPODEST_ID_IDX created.index IDX34_ITEM_REFERENCE_IDX created.index IDX35_PARENT_FOLDER_IDX created.index JIRESOURCEFOLDER_VERSION_INDEX created.index IDX28_RESOURCE_ID_IDX created.index JIRESOURCE_CHILDRENFOLDER_IDX created.index JIRESOURCE_PARENT_FOLDER_INDEX created.index IDX36_RESOURCE_ID_IDX created.Error starting at line : 1,130 in command -create index uri_index on JIObjectPermission (uri(255))Error at Command Line : 1,130 Column : 47Error report -SQL Error: ORA-00904: "URI": invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: *Action: Link to comment Share on other sites More sharing options...
reportdev Posted July 24, 2018 Share Posted July 24, 2018 It looks like Oracle repository is not supported for Community editionhttps://community.jaspersoft.com/questions/1038096/oracle-repository-jasperreports-server-community-63Check the comments made by the staff on above question Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now