Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. grantsdale

    Micros 4.1 SQL DB will not start

    Fair enough, thanks again. Really appreciate it.
  2. grantsdale

    Micros 4.1 SQL DB will not start

    I took your advice and restored from an old DB. Everything's now working correctly, last night closed correctly, everything seems to be ok. One thing left - any way I can export the credit card transactions from the broken DB from 10/19 to 10/21 and then import them into the working DB so I...
  3. grantsdale

    Micros 4.1 SQL DB will not start

    Here's where I'm at right now: Credit Card Batching errors out. The batch program tells me the following: Error #9729 : Key violation. Error #13059 : [Sybase][ODBC Driver][Adaptive Server Anywhere]Internal database error *** ERROR *** Assertion failed: 201501 (9.0.2.3586) Pag Error #13059 ...
  4. grantsdale

    Micros 4.1 SQL DB will not start

    Looks like I spoke too soon: SQLExecDirect: (S1000)[Sybase][ODBC Driver][Adaptive Server Anywhere]Internal database error *** ERROR *** Assertion failed: 201501 (9.0.2.3586) Page for requested record not a table page or record not present on page -- transaction rolled back SQLTransact...
  5. grantsdale

    Micros 4.1 SQL DB will not start

    Everything seems to be up and running now. Was able to run autosequences and no problems. Was not able to rebuild the database, however. Not too worried about that currently. Anyway - thanks a million pmegan. Would have been completely screwed without your help. I owe you a beer.
  6. grantsdale

    Micros 4.1 SQL DB will not start

    In the 'diff' column its mostly all 1's, but shift_rvc_emp_ttl is 4 and dly_rvc_fixed_prd_mi_ttl is 86080. Do I need to be concerned about those?
  7. grantsdale

    Micros 4.1 SQL DB will not start

    Under trans_cnt it says 2.
  8. grantsdale

    Micros 4.1 SQL DB will not start

    I'm getting errors on the first 2 unfortunately. First one says - syntax error near end of line (even after adding the closing parenthesis, and the second is 'function or reference to 'trans_seq' in the order by clause is invalid'. Third one does run, and only comes up with 34 items. I guess...
  9. grantsdale

    Micros 4.1 SQL DB will not start

    Ok, that worked - well, not on the user I was using, but I was able to do it on a new user. The user I was in showed all blanks after running the first query. Ran the rebuild, and it failed. I checked the log and got this: Unloading "micros"."trans_dtl" into trans_dtl (relative to server)...
  10. grantsdale

    Micros 4.1 SQL DB will not start

    Ok, I did find the RES Update for 4.1. I tried just running that again, didn't change anything.
  11. grantsdale

    Micros 4.1 SQL DB will not start

    Three problems 1 - No snapshot. The idiot that did this setup installed VMWare Player instead of Workstation, so I'm limited on what I can do. I'll fix it eventually, but can't really worry about that at this point. I did a manual backup of the VM, which will have to do for fallback purposes...
  12. grantsdale

    Micros 4.1 SQL DB will not start

    So it seems that the workstation terminals CAN interact with the database, but the DB crashes out at some point. Autosequence 10202 step 1 of type S has begun. Post Time Period Sales {CALL MICROS.sp_R_time_period()} CSeatingSectionLayout::UpdateLastActiveLayout FAILED -...
  13. grantsdale

    Micros 4.1 SQL DB will not start

    pmegan - Thank you!!! Huge progress, although not there yet. I used the second method (the first didn't work, unfortunately.) After that, I am able to run all the programs on the server, get the SQL up and running, and access the db. However, when a terminal comes online, it asks if it...
  14. grantsdale

    Micros 4.1 SQL DB will not start

    Yup, I've tried it - doesn't change anything. Still starts and stops.
  15. grantsdale

    Micros 4.1 SQL DB will not start

    @Mauriciose 1) Tried it (and just again after I read your suggestion.) No change. Have tried a couple of users, including newly created ones. 2) I can. Did not change PC name or IP. Still the same. @DJensen999: Right now I just created a new user for it of 'test'
  16. grantsdale

    Micros 4.1 SQL DB will not start

    Can't find it there but I can get to it from Sybase Central. Everything looks as it should, but when I try to do 'test connection' from there I get 'database server not found'. If I try to start the sql service manually from services, it tells me it starts and then stops.
  17. grantsdale

    Micros 4.1 SQL DB will not start

    First part looks good. Second part - the login tab where? I can't restore from backup because I can't get the DB service running. Otherwise I would have tried that already. Thanks.
  18. grantsdale

    Micros 4.1 SQL DB will not start

    Yes, I have. Unfortunately - unless I'm doing something wrong - it wants the encryption key to start it from there, which I do not have.
  19. grantsdale

    Micros 4.1 SQL DB will not start

    I should mention that this started after maint/EOD last night.
  20. grantsdale

    Micros 4.1 SQL DB will not start

    Hi all, Having an issue with a customer I recently took over. Its a Micros 3700 (v4.10) setup inside a VM running XP. They called me a couple hours ago with an issue, saying they couldn't get into the system. I've been working on it, but I can't get Sybase to fire up the SQL DB. Here are the...

Part and Inventory Search

Back
Top