This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Getting Error 27516. when installing new database with schema version.
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 19, 2014
12:43 PM
Getting Error 27516. when installing new database with schema version.
I am getting following error when I am installing a new database with InstallShield 2014 with specified version. Although I have a table 'dbo.InstallShield' on database server 'TestServer'.
I am connecting with database with user 'sa', which is default administrator on database server.
Error 27516. Error writing schema version to Microsoft SQL Server 'TestServer\SQLEXPRESS'. Database: 'TestDB'. The statement has been terminated. (3621)
I simply created a SQL Connection on right clicking SQL Script main node and write database name 'TestDB' on Catalog Name
Checked checkbox 'Create Catalog if Absent'
Then insert my Database script under SQL Connection.
Provide Schema Version '00004.00003.00001.00001' in General Tab.
It seems that Installshield could not write database schema version in this table.
Need Help what is wrong?
I am connecting with database with user 'sa', which is default administrator on database server.
Error 27516. Error writing schema version to Microsoft SQL Server 'TestServer\SQLEXPRESS'. Database: 'TestDB'. The statement has been terminated. (3621)
I simply created a SQL Connection on right clicking SQL Script main node and write database name 'TestDB' on Catalog Name
Checked checkbox 'Create Catalog if Absent'
Then insert my Database script under SQL Connection.
Provide Schema Version '00004.00003.00001.00001' in General Tab.
It seems that Installshield could not write database schema version in this table.
Need Help what is wrong?
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 19, 2014
01:35 PM
The data type of the column that stores schema versions is defined as char (15). The string length of your schema version is longer than expected. To get it workaround, you need to change the data size of the ISSchema column of the InstallShield table by following the steps below:
[LIST=1]
Open your InstallShield project.
Go to the Direct Editor view.
Find the ISSQLDBMetaData table.
Change the value of the ScriptVersion_ColumnType from "char (15)" to "char (100)"
Rebuild your release.
Note that you need to delete the InstallShield table manually before executing your setup if it's already created on the target database.
Hope that helps.
[LIST=1]
Note that you need to delete the InstallShield table manually before executing your setup if it's already created on the target database.
Hope that helps.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 20, 2014
07:06 AM
Thanks this is working
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 03, 2015
12:59 AM
Having to include SQL scripts in our installation soon, I am investigating the SQL Scripts functionality.
Running the scripts in a test install worked fine, until I added a Schema Version using the format as shown in the label on top of the textbox:
Schema Version (xxxxx.xxxxx.xxxxx.xxxxx):
So nicely entering 00000.00000.00000.00001 as the Schema Version caused the error (as described by fmshafiq) to appear.
This thread helped while after changing the Schema Version to 0.0.0.1, everything works as expected.
However, originally I entered a value in the expected format xxxxx.xxxxx.xxxxx.xxxxx (obviously string length 24) that apparently is longer than the expected string length for the column that is supposed to contain it.
It would be nice if the data type of the column and the Schema Version format are in sync, e.g. a format of xxx.xxx.xxx.xxx (string length 15) is suggested on top of the Schema Version textbox.
Running the scripts in a test install worked fine, until I added a Schema Version using the format as shown in the label on top of the textbox:
Schema Version (xxxxx.xxxxx.xxxxx.xxxxx):
So nicely entering 00000.00000.00000.00001 as the Schema Version caused the error (as described by fmshafiq) to appear.
This thread helped while after changing the Schema Version to 0.0.0.1, everything works as expected.
However, originally I entered a value in the expected format xxxxx.xxxxx.xxxxx.xxxxx (obviously string length 24) that apparently is longer than the expected string length for the column that is supposed to contain it.
hidenori wrote:
The data type of the column that stores schema versions is defined as char (15). The string length of your schema version is longer than expected. To get it workaround, you need to change the data size of the ISSchema column of the InstallShield table ...
It would be nice if the data type of the column and the Schema Version format are in sync, e.g. a format of xxx.xxx.xxx.xxx (string length 15) is suggested on top of the Schema Version textbox.