Sage 100

 View Only

  • 1.  Accessing Database In Crystal

    Posted 12-12-2019 09:23
    Very strange...crystal reports was running perfectly...suddenly a specific report stays with the “accessing database” message at the time you run it...and it stays there. I have verified the database before running it, and everything looks fine... what else could I look into????

    ---------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ---------------------------------


  • 2.  RE: Accessing Database In Crystal

    Posted 12-12-2019 09:42
    Running from the Sage menu or via designer?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Accessing Database In Crystal

    Posted 12-12-2019 09:43
    Both...since it was happening in the menu...I tried in at the server thru designer...with same results...

    ---------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ---------------------------------



    Original Message


  • 4.  RE: Accessing Database In Crystal

    Posted 12-12-2019 09:44
    It is only happening in some reports...not all....that is why I have eliminated the DSN error...

    ---------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ---------------------------------



    Original Message


  • 5.  RE: Accessing Database In Crystal

    Posted 12-12-2019 10:04
    Database - Show SQL Query... then copy / paste that into an ODBC query tool (like ODBCView) and see if it works there (to verify data problem vs report problem).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 6.  RE: Accessing Database In Crystal

    Posted 12-12-2019 10:05
    This could be a bunch of things - corrupted data, etc.

    One cause I seem to run into most frequently is linking. This can be especially apparent with large data files when you are linking say an AR Invoice History Header or Detail.  Double-check your links and see if you are working with a large data table. Sometimes reordering the tables in the linking works for me. Other times I try using a left outer join if appropriate.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 7.  RE: Accessing Database In Crystal

    Posted 12-12-2019 18:02
    I understand your OP to indicate the reports worked fine before? 

    You have a bad key(s) in there. 

    Rebuild Keys. 


    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    https://www.firstmatellc.com/
    ------------------------------

    Original Message


  • 8.  RE: Accessing Database In Crystal

    Posted 10-02-2024 15:29

    Lourdes, I am going to pull on your memory banks, but wondering if you ever resolved this?  I have the same issue occurring at a client.  I have rebuilt keys and sorts, did not help.  I have scanned the tables for bad records, nothing.  When I run the reports in from a test company (backup from about a year ago) reports run quickly.  In live company reports take hours to process.  Any suggestions welcome!



    ------------------------------
    Andrea Stull | ACI Consulting
    p 714.282.0378 f 714.282.0235
    andrea@aciconsulting.com
    ------------------------------



  • 9.  RE: Accessing Database In Crystal

    Posted 10-02-2024 15:43

    I do not remember the resolution on that case...but, it happened again a couple of weeks ago.  I added to the troubleshooting running the CHECKDATE utility to confirm no bad dates.  I ended up redoing the report and the error disappeared...maybe it was a bad link....



    ------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ------------------------------

    Original Message


  • 10.  RE: Accessing Database In Crystal

    Posted 10-02-2024 15:53

    Thanks so much for the quick response Lourdes!  I appreciate it.  I have also tried rebuilding the report, but no luck there.



    ------------------------------
    Andrea Stull | ACI Consulting
    p 714.282.0378 f 714.282.0235
    andrea@aciconsulting.com
    ------------------------------

    Original Message


Related Content