Search results for query: *

Fair enough, thanks again. Really appreciate it.

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...

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 ...

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...

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.

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?

Under trans_cnt it says 2.

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...

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)...

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

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...

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 -...

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...

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

@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'

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.

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.

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.

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

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...