Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-31724

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
    • Labels:
    • Environment:


      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]


        1. LPS-31724.gif
          745 kB
        2. Sybase 6.0.x 20131031.txt
          0.9 kB
        3. Sybase 6.1.x 20131031.txt
          0.7 kB
        4. Sybase Master 20131031.txt
          0.6 kB



            • Votes:
              0 Vote for this issue
              2 Start watching this issue


              • Created:
                Days since last comment:
                6 years, 36 weeks ago


                Version Package
                6.0.X EE
                6.1.X EE
                6.2.X EE
                7.0.0 M3