Import using REPOTOOLS Fails
I've followed the instructions for upgrading from version 2.0.0 to v. 2.0.1.
I'm using a SQL Server 2008 server to keep the Jazz database. I've already copied the jdbc files to the correct folder installdir/server/sqlserver
However when importing the repositories from version 2.0.0 to v 2.0.1 I get the following error messages on the command line window:
CRJAZ0813I Failed to drop the table "CONTRIBUTOR_ASSIGNMENT" from the schema "APT_SNAPSHOT".
The database tables were not created.
The data will not be imported.
When I look at the log file the error is the following:
Caused by:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'APT_SNAPSHOT.CONTRIBUTOR_ASSIGNMENT', because it does not exist or you do not have permission.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
Can anyone help? I'm on a time crunch and need to get this imported ASAP.
Thanks,
-Vic
I'm using a SQL Server 2008 server to keep the Jazz database. I've already copied the jdbc files to the correct folder installdir/server/sqlserver
However when importing the repositories from version 2.0.0 to v 2.0.1 I get the following error messages on the command line window:
CRJAZ0813I Failed to drop the table "CONTRIBUTOR_ASSIGNMENT" from the schema "APT_SNAPSHOT".
The database tables were not created.
The data will not be imported.
When I look at the log file the error is the following:
Caused by:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'APT_SNAPSHOT.CONTRIBUTOR_ASSIGNMENT', because it does not exist or you do not have permission.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
Can anyone help? I'm on a time crunch and need to get this imported ASAP.
Thanks,
-Vic
One answer
Hi Vic,
Have you checked your DB permissions for your user?
In our documentation we recommend a membership in the sysadmin fixed server role, or ownership of the database (dbo).
(ref: http://publib.boulder.ibm.com/infocenter/rqmhelp/v2r0/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_sql.html)
In particular, ALTER permission is needed to drop tables.
(ref: http://msdn.microsoft.com/en-us/library/ms173790.aspx)
Hope that helps, and let us know how it goes.
Regards,
John Nason
Have you checked your DB permissions for your user?
In our documentation we recommend a membership in the sysadmin fixed server role, or ownership of the database (dbo).
(ref: http://publib.boulder.ibm.com/infocenter/rqmhelp/v2r0/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_sql.html)
In particular, ALTER permission is needed to drop tables.
(ref: http://msdn.microsoft.com/en-us/library/ms173790.aspx)
Hope that helps, and let us know how it goes.
Regards,
John Nason
I've followed the instructions for upgrading from version 2.0.0 to v. 2.0.1.
I'm using a SQL Server 2008 server to keep the Jazz database. I've already copied the jdbc files to the correct folder installdir/server/sqlserver
However when importing the repositories from version 2.0.0 to v 2.0.1 I get the following error messages on the command line window:
CRJAZ0813I Failed to drop the table "CONTRIBUTOR_ASSIGNMENT" from the schema "APT_SNAPSHOT".
The database tables were not created.
The data will not be imported.
When I look at the log file the error is the following:
Caused by:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'APT_SNAPSHOT.CONTRIBUTOR_ASSIGNMENT', because it does not exist or you do not have permission.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
Can anyone help? I'm on a time crunch and need to get this imported ASAP.
Thanks,
-Vic
Comments
I had checked permissions and the user already had dbo permissions already.
In the end, I had to delete the database and create a new one, then run "repotools -createtables" to create all the objects.
After that I was able to use "repotools -import" to bring in the repositories.
Is it possible that the schema for the database had been modified with one of the ifix patches that would allow the "upgrade"? We were running a 2.0.0 schema with no modifications. We had not applied any of the ifix patches to our environment.
Thanks for the help.
Comments
Ron Felice
Jun 08 '14, 6:06 p.m.I am having the same problem.
Upgrading from 1.01.1 to 2.0.0.2 Standard w/Derby
Dennis Upton
Jun 08 '14, 6:07 p.m.My customer is having the same issue. Can't drop tables, so the import can't continue.
2.0.0.1 iFix5 to 2.0.1 with an Oracle DB in this case.
Eliya Voldman
JAZZ DEVELOPER Jun 08 '14, 6:07 p.m.I'm following instructions from info-center http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/topic/com.ibm.team.install.doc/topics/t_e_server_installation_setup_sql.html?resultof=%22%53%51%4c%22%20%22%73%71%6c%22%20 .
I'm using default values from teamserver.properties file for db name and owner.
I'm able to connect to db but fail to create or drop the tables.
I checked that my user jazzDBuser has dbo permission.
Any idea what could be wrong?
Will delete/create a new db help to create the tables?
Thanks.