Tuesday, February 05, 2013 12:40 PM nvardar wrote:
> I am trying to run below query;
>=20
> SELECT
> tbl.id,
> tbl.day,
> tbl.week,
> tbl.appfailure,
> tbl.appname,
> tbl.deviceid,
> ext6.DIM_NAME,
> ext7.DIM_NAME,
> ext8.DIM_NAME,
> ext9.DIM_NAME,
> tbl.starttime
> FROM
> APPSTARTEVT tbl
> left outer join DIM_deviceMakeModel ext6 on
> (ext6.DIM_ID=3Dtbl.devicemakemodel)
> left outer join DIM_devicePlatformType ext7 on
> (ext7.DIM_ID=3Dtbl.deviceplatformtype)
> left outer join DIM_deviceVersion ext8 on
> (ext8.DIM_ID=3Dtbl.deviceversion)
> left outer join DIM_operator ext9 on (ext9.DIM_ID=3Dtbl.operator)
> ORDER BY
> tbl.id ASC
>=20
> throws;
>=20
> >[Error] Script lines: 1-20 -------------------------
> ERROR: Node 2 has aborted execution, cause is:
> com.edb.gridsql.exception.XDBServerException :
> java.lang.NullPointerException
> QUERY: SELECT "TMPTT6624_1"."deviceplatformtype" AS
> "deviceplatformtype","TMPTT6624_1"."XSERIALID0" AS
> "XSERIALID0","TMPTT6624_1"."XONODEID0" AS "XONODEID0" FROM
> "TMPTT6624_1"
> LEFT OUTER JOIN "dim_deviceplatformtype" "ext7" ON ("ext7"."dim_id" =
=3D
> "TMPTT6624_1"."deviceplatformtype") WHERE "ext7"."dim_id" IS NULL
> Line: 1 =03
>=20
> [Executed: 2/4/13 11:07:08 PM PST ] [Execution: 0/ms]
>=20
>=20
> exception.
>=20
> Is there anything i am missing.
Why the query is different in Exception?
Can you try with=20
SELECT
tbl.id,
tbl.day,
tbl.week,
tbl.appfailure,
tbl.appname,
tbl.deviceid,
ext6.DIM_NAME,
tbl.starttime
FROM
APPSTARTEVT tbl
left outer join DIM_deviceMakeModel ext6 on
(ext6.DIM_ID=3Dtbl.devicemakemodel)
ORDER BY tbl.id ASC
Also as Pavel has pointed, send this to General mailing list.=20
With Regards,
Amit Kapila.