ORA-01017: invalid username/password; logon denied

[ak]

I am at the 3.4.3 Create Crcdata Tables section of the i2b2 installation guide located here. I rant the following command on my Windows machine as mentioned in the instructions:

%ANT_HOME%\bin\ant.bat -f data_build.xml create_crcdata_tables_release_1-7

However, I ended up getting the following error (screenshot below).

Could anyone tell me why I am getting this error. I can see that there is some login credentials problem but I am not sure how I would provide that information to the data_build.xml ? When I opened the XML file, I saw the following :

<target name="create_crcdata_tables_release_1-7" depends="init">

<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}" classpathref="classpath" onerror="continue"           autocommit="true">

<transaction src="./scripts/crc_create_datamart_${db.type}.sql" />

<transaction src="./scripts/crc_create_query_${db.type}.sql" />

<transaction src="./scripts/crc_create_uploader_${db.type}.sql" />

</sql>

</target>

And I am not sure, from where the db.username and db.password are getting pulled up. Please let me know if anyone has gone through the same problem before or any idea how to resolve?

Thanks

[Phillips, Lori C.]

In the crcdata folder there is a db.properties file ; you need to update this file

--
You received this message because you are subscribed to the Google Groups "i2b2 Install Help" group.
To unsubscribe from this group and stop receiving emails from it, send an email to i2b2-install-h...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

The information in this e-mail is intended only for the person to whom it is
addressed. If you believe this e-mail was sent to you in error and the e-mail
contains patient information, please contact the Partners Compliance HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you in error
but does not contain patient information, please contact the sender and properly
dispose of the e-mail.

[ak]

Thanks for your reply, Lori. I checked the db.properties and it looks like it has the credentials that I used while creating the tables before. I am pasting the content of the file below for Crcdata folder :

# Database setup parameters 

db.type=oracle

db.username=i2b2demodata

db.password=demouser

db.server=localhost:1521:xe

db.driver=oracle.jdbc.driver.OracleDriver

db.url=jdbc:oracle:thin:@127.0.0.1:1521:xe

db.project=demo

Could you tell me if there any other changes required in that file?

[ak]

I actually got that working. I forgot to create i2b2demodata and hence I was getting that error.