problems with table 2000000047 in a web services

gorvega79 · 2011-04-11

Hi all

i have a problem with table 2000000047 Server when i try to get a value from a function of the web service, in the explorer i can see the services well and i can add a reference in visual studio 2008 without problems and compiling fine. but when i´m using the program and call to the web services the error is :

"Metadata for object of type Table with id 2000000047 is in a failed state. This is caused by a previous exception:
Table 2000000047 is not available and cannot be opened. "

the user is in domain and have administrator rights, the web services are running with that user and delegation is ok,the licence is ok, the user´s spns are ok. i don´t know where is the problem ](*,)

the program in the c# is
int vStock;
string vProd="",vlocation="";
vProd = "DARCHIVADOR";
vlocation = "EBI";
var vConWS = new vRefWs.CodeunitStock_Binding();
vConWS.UseDefaultCredentials = true;
vStock = vConWS.SacarStock(vProd,vlocation);// here is the problem
MessageBox.Show("the stock is:"+Convert.ToString(vStock));

thank you so much.

mohana_cse06 · 2011-04-11

Did you try Compiling table 2000000047?

gorvega79 · 2011-04-11

thank you mohana

but how can i compile this table if i can´t watch it, i have developer licence but in the object designer i cant watch server table then i don´t know how compile the table.

mohana_cse06 · 2011-04-11

Have any of you modified server name by any chance?

create a new form with wizard and try.

gorvega79 · 2011-04-11

hi again

the server table has never modified and i can create a form with server table without problems. any idea.

thank you

frost_amo · 2011-04-11

Unfortunatelly It is not possible to work with table 2000000047 (Server) in RTC as wel as through Webservices.
You can check this topic for more info. viewtopic.php?f=32&t=36277&start=0

gorvega79 · 2011-04-11

thank you

but, we don´t want do anything with the server table, we have a problem with table, we execute a function from a codeunit that we call with the web service but in the codeunit there aren´t references about server table, nothing. we want to consume the web service but we don´t do nothing to this table

frost_amo · 2011-04-11

Probably your codeunit calls, in turn, other codeunit (or another object). And this other object can have the reference to Server table...

gorvega79 · 2011-04-11

hello

i find the mistake in the codeunit 1 I have this code:

CLEAR(Tserver);
Tserver.SETRANGE("My Server",TRUE);
IF Tserver.FINDFIRST THEN BEGIN
IF Tserver."Server Name" = 'nameserver' THEN
MESSAGE('You are working in ausbert database');
END;

with the function ISSERVICETIER only process the code if that code is called from a webservice.

IF NOT ISSERVICETIER THEN BEGIN
CLEAR(Tserver);
Tserver.SETRANGE("My Server",TRUE);
IF Tserver.FINDFIRST THEN BEGIN
IF Tserver."Server Name" = 'nameserver' THEN
MESSAGE('You are working in ausbert database');
END;

thank you for all!!!

problems with table 2000000047 in a web services

Answers

Categories