Best Of

Re: How can I get all 9 digits of precision in systimestamp?

Thanks Bruno. The fact that I can get the additional precision from my OS makes me think Oracle should be able to get it, too, and use it to populate the timestamp(9) for me. I consider this to be a bug - why offer 9 digits but only populate 6 of them?

The White Rabbit Project is indeed amazing! Thanks for the link - I'd never heard of it. We humans are doing some amazing things!

Lisa Tansey

1

Re: Rename 'Performance Management' tab

Done - thanks so much

DebbieB

1

Re: startup database

I got it . thanks for all your help

sreeninatla

1

Re: Server Busy Error After Session Timeout in IP 25.1

Hi,

Server busy is very bad news and means whatever you did caused Siebel to crash. We need to see your crash.txt, extracted/sorted FDR for just the thread that caused the crash and the 4-1-1 Siebel log file for the user that caused the crash in order to be able to help further.

Also especially since this is production you should check s_diag to see how often you are crashing and how many users are being impacted with each crash.

Until you find and fix the root cause suggest you increase MTS so that the users are "thinned" across more server processes to reduce the impact of each crash. E.g. increasing MTS from 10 to 20 will cut the number of users in half as long as MIN and MAX MTS are both set the same.

HTH,

R

P.S. You can also consider changing your timeout value so that timeouts happen less frequently to state the obvious.

Robert Ponder

1

Re: Should gpu utility be run on all siebel servers in a migration installation

Hello @User_YJ1G2,

Thank you for posting your queries about spu and gpu utilities for password AES encryption.

I hope it is one time encryption if fine and make use of same one while creating other others services.

Also, gpu as it is enterprise level, you can make use of once or same.

$SIEBEL_ROOT/siebsrvr/lib/gpu -g localhost:2320 -e esia81 -u SADMIN -p

Below one also at enterprise level

change param password=<pwd_value> for compdef <comp_name>

Where as this is server level

change param password=<pwd_value> for comp <comp_name> server <server_name>

But you can make use of compdef level which is enterprise and reflects to all servers where ever it enabled.

But still you can test it to make sure.

Regards,

Mallik Kalluri

Mallik Kalluri -Oracle

1

Re: Should gpu utility be run on all siebel servers in a migration installation

SPU is run once, in "gateway" context:

"Source the siebenv script from the Siebel Gateway installation directory"

it gives you a new password.

GPU is run in siebel server context and you run gpu again on each siebel server.

https://docs.oracle.com/cd/G30554_01/books/SiebInst/c-Updating-the-Siebel-Server-System-Service-and-Server-Components-to-Use-AES-Password-Encryption-ahw4068698.html

Thiago Burke-Oracle

1

Re: How to pass JWT as Header Parameter on a Consumer type Application Service

Hi - This is a limitation in UI tester as field is restricted to 255.. If you are testing you can test using postman and in real world scenario you can add the header using peoplecode.

Not sure if you are looking for something else.

Local Message &Request, &Response;

Local boolean &b;
/* createRequest */

&Request = CreateMessage(Message.IB_GENERIC);

&Request.IBInfo.IBConnectorInfo.ConnectorName = "HTTPTARGET";

&Request.IBInfo.IBConnectorInfo.ConnectorClassName = "HttpTargetConnector";
/* setHTTPProperties */

&b = &Request.IBInfo.IBConnectorInfo.AddConnectorProperties("Method", "GET", %HttpProperty);

&b = &Request.IBInfo.IBConnectorInfo.AddConnectorProperties("URL", "Pass your URL", %HttpProperty);
/* setHeaders */

&b = &Request.IBInfo.IBConnectorInfo.AddConnectorProperties("accept", "application/json", %Header);

&b = &Request.IBInfo.IBConnectorInfo.AddConnectorProperties("authorization", &oauthtoken, %Header);


/* getResponse */

Local string &json;

&Response = %IntBroker.ConnectorRequest(&Request, True);

&json = &Response.GetContentString();

WinMessage(&json);

-Velu

Velu Angusamy

1

Re: How to pass JWT as Header Parameter on a Consumer type Application Service

Hi Matheshwaran,

I was able to use the delivered app package PTCBAPPLSVCDEFN and going through different app classes listed under that package to consume the web service. The sample code snippet is as below.

&base = create PTCBAPPLSVCDEFN:ApplicationServiceBase(); /* instantiate and return the base object */
&ServiceAPI = &base.createService("ASF Service Name", "ASF Service Root Name", "URI_Index", %AppService_HTTP_GET);
&ServiceAPI.setRequestHeader("Bearer", "Token");

Thank you.

Regards,
Pravin Mate