error in view data

chulett · Post by **chulett** » Thu Sep 11, 2008 9:11 pm

Could you expand on the nature of this bug with 7.x and Oracle and the DRS stage? I'm sure there's plenty of people using this combination without issue, I know I am.

Renita · Post by **Renita** » Thu Sep 11, 2008 11:38 pm

Hi Chulett,

I found a write up on the ibm ascential site which states the following.

DESCRIPTION:
Using using DRS Stage with DBMS Type = ORACLE, and the number of
characters in the generated SQL FROM clause exceeds 64, running
the job or performing a viewdata causes the uvsh and dsapi_slave
to produce a core dump, with a SIGSEGV.

FURTHER INFORMATION:
If View Data is tried from the Designer client , this causes a
core dump to occur (SIGSEGV) in the dsapi_slave process, causing
the connection to sever with the following messages:

<messages>
<message number=1>
Error calling subroutine: DSD.Browse (Action=3); check DataStage
is set up correctly in project proj01
</message>
<message number=2>
Data Browser: Data source is empty
</message>
<message number=3>
Error calling subroutine: DSD.Browse (Action=2); check DataStage
is set up correctly in project proj01
(The connection is broken (81002))
</message>
<message number=4>
Error calling subroutine: *DataStage*DSR.ADMIN (Action=38);
check DataStage is set up correctly in project proj01
(The connection is broken (81002))
</message>
<message number=5>
Error calling subroutine: *DataStage*DSR.ADMIN (Action=36);
check DataStage is set up correctly in project proj01
(The connection is broken (81002))
</message>
</messages>
Local fix
The problem does not occur when using the ODBC DBMS Type to
connect to Oracle.

Problem conclusion
Problem is fixed in the patch for 8.0.1 fp1
Temporary fix
The problem does not occur when using the ODBC DBMS Type to
connect to Oracle.

Hope this helps you all. I know and understand that the server edition is really unstable but each day we learn of another defect

Thanks,
Renita

ray.wurlod · Post by **ray.wurlod** » Thu Sep 11, 2008 11:48 pm

I guess all of Craig's FROM clauses are shorter than 64 characters!

chulett · Post by **chulett** » Fri Sep 12, 2008 12:25 am

Pfffttt... I guess so. There's actually very few times I've used the DRS stage, not having any need to suddenly change from one RDMBS to another, I pretty much stick with the OCI stage.

Renita wrote:I know and understand that the server edition is really unstable but each day we learn of another defect

Really unstable? There are days when *I* may be, but that's not anything I would have considered saying about the Server product. PX maybe, but not Server.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 12, 2008 12:53 am

I was going to challenge that too, but held back seeing the version number. The product has not changed, but the platform on which it runs certainly has. It now has to run over Information Server, effectively using a one-node configuration file on the server machine. The service-oriented metadata and other changes may also have had an effect. Once I get a chance to play with this "in anger" I may have more to say.

Most of my 7.5 server-only clients seem to want to stay on 7.5, not least because of its robustness. Mainly, though, they cite the added hardware, administration and (shock!) training costs needed for the new version.

chulett · Post by **chulett** » Fri Sep 12, 2008 1:17 am

ray.wurlod wrote:I was going to challenge that too, but held back seeing the version number.

We are talking 7.x here, not 8.x are we not? That was the impression I was under and speaking to, the long standing 7.x release. We're still on 7.5.1A and may go to 7.5.3 but the product is reaching the end of its life cycle at this client so there's no incentive to upgrade past that at all.

Now, if we're talking the 8.x release, I guess I could understand the comment. It's still... young.