Forum

Welcome Guest! To enable all features please try to register or login.
darinka
#1 Posted: : 11 April 2012 08:51:39(UTC)
darinka

Rank: PA User

You have been a member since:: 07/09/2010(UTC)
Posts: 4

Z nadgradnjo bulida na 5.5.56. 20 rev 17395 so nam izginili vsi izpisi. Včeraj smo nadgradili bazo, po dolgih naporih so se izpisi pojavili, a danes je zopet vse prazno( računi, bruto bilance, plače ...) Kaj nam je storiti ?
mihazal
#2 Posted: : 13 April 2012 09:37:35(UTC)
mihazal

Rank: Member

You have been a member since:: 07/06/2011(UTC)
Posts: 28

Pozdravljeni!

Predvidevam da imate sql manager 2005 in build 620 ali 621, saj smo tu v redkih primerih zasledili napačno jemanje logiranega userja (gre za napako v exe-ju, ki se odpravlja z remarkom 34357).

z querijem Select SYSTEM_USER se preveri, če rezultat ni enak uporabniškemu imenu uporabnika, ki je prijavljen v PA.
Če rezultat ni enak, ne deluje (gre skozi pregled avtorizacij).

Začasna rešitev (dokler ne izide uradni popravek exe-ja) je, da v Pantheonu v Nastavitve - program - SQL urejevalnik, vnesete:

ALTER function [dbo].[fPA_UserGetCurrentUserId]
()
returns integer
as

begin
return IsNull((select top 1 anUserId from tHE_SetSubjContact where acUserId = 'DK'), 0)
end


kjer krepko označeno številko 1 zamenjate s številko vašega userja in DK z imenom vašega userja.
(vkolikor vam ne bo šlo, prijavite težavo na helpdesk in vam bomo pomagali)

Hvala in lp,
Miha
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2026, Yet Another Forum.NET
This page was generated in 0,444 seconds.