Errors when building a full database in Sybase

• Type: Bug
• Status: Closed
• Resolution: Won't Fix
• Affects Version/s: 6.0.X EE, 6.1.30 EE GA3, 6.2.0 CE M3, 6.2.0 CE RC2
• Fix Version/s: 6.0.X EE, 6.1.X EE, 6.2.X EE, 7.0.0 M3
• Component/s: Environments, Environments > Databases
• Labels:
  • QA-R
• Environment:
  Hide

  Tomcat 7.0.27 + Sybase 15.5. Portal 6.0.x EE GIT ID: a17ab4427c0988f7fb39f60535efd94ab10186a7. ; Tomcat 7.0.40 + Sybase 15.5. Portal 6.1.x EE GIT ID: 8ca728b8d2622e534bba7b5364682820592ab0f4. ; Tomcat 7.0.42 + Sybase 15.5. Portal 6.2.x GIT ID: 8ef2e536d23db3e5906418221686002b4727d2b7.

  Show

  Tomcat 7.0.27 + Sybase 15.5. Portal 6.0.x EE GIT ID: a17ab4427c0988f7fb39f60535efd94ab10186a7. Tomcat 7.0.40 + Sybase 15.5. Portal 6.1.x EE GIT ID: 8ca728b8d2622e534bba7b5364682820592ab0f4. Tomcat 7.0.42 + Sybase 15.5. Portal 6.2.x GIT ID: 8ef2e536d23db3e5906418221686002b4727d2b7.
• Epic/Theme:
  • Platform
• Fix Priority: 3

Here are the steps to reproduce:

1. Open Sybase Central
2. Add a new database
3. Go to Adaptive Server Enterprise -> Default -> sa -> Databases
4. Click Add Database
5. Type lportal in the name field and click Next
6. Click Add, select "master" and type in an MB value (1400 is recommended or however many available)
7. Click Next
8. Flag "With Override"
9. Click Next
10. Click Next again
11. Click Finish
12. Right click lportal and click Properties
13. Under Options, flag "allow nulls by default" and "select into/bulkcopy/pllsort"
14. Apply and click OK
15. Open create-sybase.sql and replace "use master" at the top with "use lportal"
16. Run the following command: isql -U sa -P -i [Directory where create-sybase.sql is located]