Jump to content

upgrade to 6.1 - ORA-00904: "REPOPROFIL0_"."OWNER": invalid identifier


alamuvinai

Recommended Posts

Hi All, I am trying to upgrade from version 5.6 to 6.1; made lot of customization code in 5.6; need to integrate those changes to 6.1;

steps taken so far:

1) download 6.1 source code, built successfully; deployed war file in tomcat. if using post-gres sample db, able to login from UI.

2) but i've to use the oracle jasper db. right now using the oracle jasper 5.6 db that I've already. but getting error on tomcat start up.

3) How do I fix this error. I am trying to connect from jasper 6.1 source code to jasper5.6 database.

4) Is there any db script for oracle that needs to be run on oracle 5.6?  Can someone please let me know ASAP?

ORA-00904: "REPOPROFIL0_"."OWNER": invalid identifier org.springframework.beans.factory.BeanCreationException:

Error creating bean with name 'proOnStartPropagator' defined in ServletContext resource [/WEB-INF/applicationContext-onStart-web-pro.xml]: Invocatio n of init method failed;

nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select repoprofil0_.id as id12_, repoprofil0_.attrName as attrNam e12_, repoprofil0_.attrValue as attrValue12_, repoprofil0_.description as descript4_12_, repoprofil0_.owner as owner12_, repoprofil0_.principalobjectclass as principa6_12_, repoprofil0_.principalobjectid a s principa7_12_ from JIProfileAttribute repoprofil0_ where repoprofil0_.principalobjectclass=? and repoprofil0_.principalobjectid=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1514) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)

Link to comment
Share on other sites

  • 3 weeks later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...