Error after upgrade to 7.1.1.5

Hi Gang,

I am no longer able to run any reports in Eclipse for MAXIMO 7.1.1.5. I have connected to multiple 7x database and I either get this error:

ERROR DataSet [dataSet] ORA-01004: default username feature not supported; logon denied

or this one:

ERROR DataSet [dataSet] ORA-01017: invalid username/password; logon denied

I followed all the steps in the configuration guide and my properties are set correctly in the mxreportdatasource.properties file. I don't know why this is not working. I had it working great with BIRT 2.1.2.

Any ideas?

thanks,
John

Find more posts tagged with

Comments

voller

hi john!

in your eclipse birt designer, you can switch to database developer perspective! try to add a connection to your maximo database at this view! Here you can test driver version, host url, username and password with gui support! if connection succeeds use this settings for your mxreportdatasources.properties file!

check also, if you have unzipped the the maximo scripted datasource classes and your driver classes into eclipsepluginsorg.eclipse.birt.report.viewer_2.3.2.r232_20090212birtWEB-INFclasses

hope this helps

cheers chris

jballnik

Hey Chris,

We figured it out. Take a look at this:

maximoDataSource.url=jdbc:oracle:thin:@localhost:1521:max7
maximoDataSource.driver=oracle.jdbc.driver.OracleDriver
maximoDatasource.username=maximo
maximoDataSource.password=maximo
maximoDataSource.schemaowner=maximo

See anything wrong?? The s in source for the middle maximoDatasource was in lowercase. 2 of us missed it..augh!!

thanks for all your help
John

voller

Hi John!

I also have to look twice :-)))!!!!!

However, it's working now ;-)!

chris

mholland

Does mxreportdatasource.properties need to be configured and maximo.ear dedeployed? I look in this file located at

C:ibmSMPmaximoapplicationsmaximomaximouiwebwebmoduleWEB-INFbirtscriptclasses

and all of the items appear to be commented out