Error message when logging in to SAP B1

[Former Member]

Hello,

Does anybody have a clue, on that error message when I'm trying to

log in to SAP B1: Invalid column name 'AppTime' ?

I cannot log in to SAP B1, the error message appears (from MSSQL server),

immediately after typing username/password and clicking OK on the log on

window.

Thank you,

Balazs

[Former Member · Accepted solution]

Hi,

You can easily verify by yourself that no column AppTime exists in a standard B1 installation (just tested on 2007A SP01 PL6).

You should have a reference to an external database or extension (addon)...

What addons are you using?

Regards,

Eric

[Former Member · Accepted solution]

Hello Eric,

There is no AddOn on that system. This error is caused by an SBO client re-installation (on a single client machine), which was made by the user himself, and some error occured during that process, which is unknown. Now that error message appears on server side as well.

Thank you,

Balazs

[Former Member · Accepted solution]

Hi,

Does reinstallation of client and DI API helps?

If not, I suggest logging a message with SAP Support.

Hope it helps!

Warmest Regards,

Chinho

[Former Member · Accepted solution]

Hi,

OK, I learned something... The AppTime column is in the SBO-COMMON database, exactly in the SINF table.

I'll suggest to restore a backup of the SBO-COMMON if you've got one... Else reinstall the server side of B1, with all of what it means of backups, patch to apply, etc.

Regards,

Eric