Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Posts: 1
Was thanked: 2 time(s) in 2 post(s)
|
Zrdavo
Nakon nadogradnje kod kliente na verziju 556000 nestale su autorizacije. Greska u attachment.
Isto sam uradio na KO demo bazu, isto se je desilo.
Pozdrav
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Posts: 0
Was thanked: 1 time(s) in 1 post(s)
|
Tiket 159791 moze da se zatvori.
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Posts: 0
Was thanked: 1 time(s) in 1 post(s)
|
Avtorizacije su u tablici [dbo].[tPA_SetAuthoFunc].
Predlažem, da opet nadogradite bazu na isti build. Sa nadogradnjom će se opet napuniti tablica [dbo].[tPA_SetAuthoFunc].
Ako ne pomaže onda trebamo bazu ili dostup do baze, da provjerimo šta je.
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Posts: 0
Was thanked: 1 time(s) in 1 post(s)
|
Omogucio sam korisnicima da rade tako sto sam podesio autorizacije preko ekransku formu.Nakon toga nisam imao neke intervencije. Smatram da je bolje da buduce probe radim na testnu bazu kako ne bi imali zastoja u radu. Proveritcu ovo resenje sutra, pa cu vas izvestiti.
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Posts: 0
Was thanked: 1 time(s) in 1 post(s)
|
Zdravo,
Uradio sam postupak na demo bazu i proslo je OK. Pojavila se je struktura autorizacije. Ostaje isto da uradim to i na korisnikovu bazu u da opet podesim authorizacije (mislim da je bolje da opet podesim nego da radim uvoz izvoz).
Hvala stom zavrsim kod korisnika izviestiticu vas da zatvorite tiket.
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Posts: 0
Was thanked: 1 time(s) in 1 post(s)
|
Da javi, kako je kod koristnika, jer tvoj ticket ima status Alarm, pa trebamo zatvoriti u roku, odnosno što prije ustanoviti, ako je problem kod koristnika ređen.
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Posts: 0
Was thanked: 1 time(s) in 1 post(s)
|
Zdravo,
Pokusao sam na kopiju od korisnikovu bazu. Struktura za podesavanje authorizacija se pojavila nakon nadogradnje ali nakon uvoza authorizacija opet se javio isti problem (ista greska iz attachment). Dali postoi nacin da se authorizacije nekako vrate natrag (ima oko 50 korisnika) ili mora da se opet rucno podese?
LP
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Posts: 0
Was thanked: 1 time(s) in 1 post(s)
|
Da ručno se može, ali bez baze težko je reči u čemu je tačno problem.
Ako budete imali mogučnost, da se Aleš poveže na bazu i proveri situaciju...
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Posts: 0
Was thanked: 1 time(s) in 1 post(s)
|
SQL sa kojim pronađemo greške u autorizacijama
DECLARE @cLicence CHAR(2);
SET @cLicence = `MF`--<koja licenca>;
SELECT
[dbo].[tPA_SetAuthoFunc].acFunction
, [dbo].[tPA_SetAuthoFunc].acFuncAbove
FROM
[dbo].[tPA_SetAuthoFunc]
INNER JOIN [dbo].[tPA_SetAuthoFuncLicence] ON ([dbo].[tPA_SetAuthoFunc].anQId = [dbo].[tPA_SetAuthoFuncLicence].anFunctionality_Id)
INNER JOIN [dbo].[tPA_SysLicence] ON ([dbo].[tPA_SetAuthoFuncLicence].[anLicence_Id] = [dbo].[tPA_SysLicence].[anId])
WHERE
([dbo].[tPA_SysLicence].[acCode] = @cLicence)
GROUP BY
[dbo].[tPA_SetAuthoFunc].acFunction
, [dbo].[tPA_SetAuthoFunc].acFuncAbove
HAVING
COUNT(*) > 1
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Posts: 0
Was thanked: 1 time(s) in 1 post(s)
|
SQL, ki odpravi težavo.
DELETE [dbo].[tPA_SetAuthoFunc]
FROM
[dbo].[tPA_SetAuthoFunc]
INNER JOIN (
SELECT
[dbo].[tPA_SetAuthoFunc].acFunction
, [dbo].[tPA_SetAuthoFunc].acFuncAbove
FROM
[dbo].[tPA_SetAuthoFunc]
INNER JOIN [dbo].[tPA_SetAuthoFuncLicence] ON ([dbo].[tPA_SetAuthoFunc].anQId = [dbo].[tPA_SetAuthoFuncLicence].anFunctionality_Id)
INNER JOIN [dbo].[tPA_SysLicence] ON ([dbo].[tPA_SetAuthoFuncLicence].[anLicence_Id] = [dbo].[tPA_SysLicence].[anId])
WHERE
([dbo].[tPA_SysLicence].[acCode] = @cLicence)
GROUP BY
[dbo].[tPA_SetAuthoFunc].acFunction
, [dbo].[tPA_SetAuthoFunc].acFuncAbove
HAVING
COUNT(*) > 1
) duplicates ON (duplicates.acFunction = [dbo].[tPA_SetAuthoFunc].acFunction AND duplicates.acFuncAbove = [dbo].[tPA_SetAuthoFunc].acFuncAbove)
WHERE
[dbo].[tPA_SetAuthoFunc].acUserFunc = `T`
;
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Posts: 0
Was thanked: 1 time(s) in 1 post(s)
|
|
|
|
|
|
|
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.NETThis page was generated in 0,462 seconds.