Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

The JAVA_HOME environment variable is not defined correctly

843833Oct 24 2007 — edited Feb 24 2010
When I am starting Tomcat by startup.bat, it is giving me this error ...

The JAVA_HOME environment variable is not defined correctly
This environment variable is needed to run this program
NB: JAVA_HOME should point to a JDK not a JRE


AS, I have defined JAVA_HOME correctly,

C:\Java\jdk1.5.0_13

Please help me to solve this

Comments

mrmmickle1
Answer

Got it working by modifying some SQL:

I create a union query that merged Net Other with the other categories:

SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT saw_0,saw_1 FROM ((SELECT

   saw_0,

   SUM(MassiveT.saw_3) saw_1

FROM (SELECT

   saw_0,

   saw_1,

   saw_2,

   saw_3

FROM ((SELECT

   '1. 2018 Year End HC' saw_0,

   "Department Hierarchy"."SUBLOB Name" saw_1,

   "Basic Information"."Person Number" saw_2,

   1 saw_3

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Deployment Facts"."Employee Headcount" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ((cast(substring("Gregorian Calendar"."Month Name" from 8 for 2) as integer) = 12) AND (cast("Gregorian Calendar"."Year" as integer)  = case when (cast(substring(Valueof("CURRENT_MONTH") from 8 for 2) as integer)-1) = 0 then (cast(valueof("CURRENT_YEAR") as integer) -2 ) else  (cast(valueof("CURRENT_YEAR") as integer) -1 ) end))

) UNION (SELECT

   '4. YTD Hires' saw_0,

   "Department Hierarchy"."SUBLOB Name" saw_1,

   "Basic Information"."Person Number" saw_2,

   1 saw_3

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Event Facts"."Employee Hire Count" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND (cast("Gregorian Calendar"."Year" as integer)  = case when (cast(substring(Valueof("CURRENT_MONTH") from 8 for 2) as integer)-1) = 0 then (cast(valueof("CURRENT_YEAR") as integer) -1 ) else  (cast(valueof("CURRENT_YEAR") as integer)  ) end) AND ("Gregorian Calendar"."Month Name" <=  VALUEOF("PREVIOUS_MONTH_OBIA"))

) UNION (SELECT

   '2. YTD Terminations' saw_0,

   "Department Hierarchy"."SUBLOB Name" saw_1,

   "Basic Information"."Person Number" saw_2,

   -1 saw_3

FROM "Human Resources - Workforce Deployment"

WHERE

(DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ("Job"."Job Code" <> 'LTDJBA') AND (("Workforce Event Facts"."Employee Voluntary Termination Count" > 0) OR ("Workforce Event Facts"."Employee Involuntary Termination Count" > 0)) AND (cast("Gregorian Calendar"."Year" as integer)  = case when (cast(substring(Valueof("CURRENT_MONTH") from 8 for 2) as integer)-1) = 0 then (cast(valueof("CURRENT_YEAR") as integer) -1 ) else  (cast(valueof("CURRENT_YEAR") as integer)  ) end) AND ("Gregorian Calendar"."Month Name" =  VALUEOF("PREVIOUS_MONTH_OBIA"))

) UNION (SELECT

   '3. YTD Transfer Outs' saw_0,

   "Department Hierarchy"."SUBLOB Name" saw_1,

   "Basic Information"."Person Number" saw_2,

   -1 saw_3

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Deployment Facts"."Employee Headcount" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ("Job"."Job Code" <> 'LTDJBA') AND ("Basic Information"."Person Number"||"Department Hierarchy"."SUBLOB Name" NOT IN

(

SELECT saw_1 FROM (SELECT

   "Gregorian Calendar"."Month Name" saw_0,

   "Basic Information"."Person Number"||"Department Hierarchy"."SubLOB Name" saw_1

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Deployment Facts"."Employee Headcount" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ("Gregorian Calendar"."Month Name" =  VALUEOF("PREVIOUS_MONTH_OBIA"))

) nqw_1

)) AND ("Basic Information"."Person Number"||"Department Hierarchy"."SUBLOB Name" NOT IN

(

SELECT saw_1 FROM (SELECT

   "Gregorian Calendar"."Month Name" saw_0,

   "Basic Information"."Person Number"||"Department Hierarchy"."SubLOB Name" saw_1

FROM "Human Resources - Workforce Deployment"

WHERE

(DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ("Gregorian Calendar"."Month Name" =  VALUEOF("PREVIOUS_MONTH_OBIA")) AND (("Workforce Event Facts"."Employee Voluntary Termination Count" > 0) OR ("Workforce Event Facts"."Employee Involuntary Termination Count" > 0)) AND ("Job"."Job Code" <> 'LTDJBA')

) nqw_1

)) AND (cast(substring("Gregorian Calendar"."Month Name" from 8 for 2) as integer) = 12) AND (cast("Gregorian Calendar"."Year" as integer)  = case when (cast(substring(Valueof("CURRENT_MONTH") from 8 for 2) as integer)-1) = 0 then (cast(valueof("CURRENT_YEAR") as integer) -2 ) else  (cast(valueof("CURRENT_YEAR") as integer) -1 ) end)

) UNION (SELECT

   '5. YTD Transfer Ins' saw_0,

   "Department Hierarchy"."SUBLOB Name" saw_1,

   "Basic Information"."Person Number" saw_2,

   1 saw_3

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Deployment Facts"."Employee Headcount" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ("Job"."Job Code" <> 'LTDJBA') AND ("Basic Information"."Person Number"||"Department Hierarchy"."SUBLOB Name" NOT IN

(

SELECT saw_1 FROM (SELECT

   "Gregorian Calendar"."Month Name" saw_0,

   "Basic Information"."Person Number"||"Department Hierarchy"."SubLOB Name" saw_1

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Deployment Facts"."Employee Headcount" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND (cast(substring("Gregorian Calendar"."Month Name" from 8 for 2) as integer) = 12) AND (cast("Gregorian Calendar"."Year" as integer)  = case when (cast(substring(Valueof("CURRENT_MONTH") from 8 for 2) as integer)-1) = 0 then (cast(valueof("CURRENT_YEAR") as integer) -2 ) else  (cast(valueof("CURRENT_YEAR") as integer) -1 ) end)

) nqw_1

)) AND ("Basic Information"."Person Number"||"Department Hierarchy"."SUBLOB Name" NOT IN

(

SELECT saw_1 FROM (SELECT

   "Gregorian Calendar"."Month Name" saw_0,

   "Basic Information"."Person Number"||"Department Hierarchy"."SubLOB Name" saw_1

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Event Facts"."Employee Hire Count" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND (cast("Gregorian Calendar"."Year" as integer)  = case when (cast(substring(Valueof("CURRENT_MONTH") from 8 for 2) as integer)-1) = 0 then (cast(valueof("CURRENT_YEAR") as integer) -1 ) else  (cast(valueof("CURRENT_YEAR") as integer)  ) end) AND ("Gregorian Calendar"."Month Name" <=  VALUEOF("PREVIOUS_MONTH_OBIA"))

) nqw_1

)) AND ("Gregorian Calendar"."Month Name" =  VALUEOF("PREVIOUS_MONTH_OBIA"))

)) t1 ORDER BY saw_0, saw_1, saw_2, saw_3)MassiveT

GROUP BY saw_0, saw_1 ORDER BY saw_0)

UNION

(SELECT

   '6. Net Other' saw_0,

   SUM(Massive.saw_3) saw_1

FROM (SELECT

   saw_0,

   saw_1,

   saw_2,

   saw_3

FROM ((SELECT

   '1. 2018 Year End HC' saw_0,

   "Department Hierarchy"."SUBLOB Name" saw_1,

   "Basic Information"."Person Number" saw_2,

   -1 saw_3

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Deployment Facts"."Employee Headcount" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ((cast(substring("Gregorian Calendar"."Month Name" from 8 for 2) as integer) = 12) AND (cast("Gregorian Calendar"."Year" as integer)  = case when (cast(substring(Valueof("CURRENT_MONTH") from 8 for 2) as integer)-1) = 0 then (cast(valueof("CURRENT_YEAR") as integer) -2 ) else  (cast(valueof("CURRENT_YEAR") as integer) -1 ) end))

) UNION (SELECT

   '4. YTD Hires' saw_0,

   "Department Hierarchy"."SUBLOB Name" saw_1,

   "Basic Information"."Person Number" saw_2,

   -1 saw_3

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Event Facts"."Employee Hire Count" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND (cast("Gregorian Calendar"."Year" as integer)  = case when (cast(substring(Valueof("CURRENT_MONTH") from 8 for 2) as integer)-1) = 0 then (cast(valueof("CURRENT_YEAR") as integer) -1 ) else  (cast(valueof("CURRENT_YEAR") as integer)  ) end) AND ("Gregorian Calendar"."Month Name" <=  VALUEOF("PREVIOUS_MONTH_OBIA"))

) UNION (SELECT

   '2. YTD Terminations' saw_0,

   "Department Hierarchy"."SUBLOB Name" saw_1,

   "Basic Information"."Person Number" saw_2,

   1 saw_3

FROM "Human Resources - Workforce Deployment"

WHERE

(DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ("Job"."Job Code" <> 'LTDJBA') AND (("Workforce Event Facts"."Employee Voluntary Termination Count" > 0) OR ("Workforce Event Facts"."Employee Involuntary Termination Count" > 0)) AND (cast("Gregorian Calendar"."Year" as integer)  = case when (cast(substring(Valueof("CURRENT_MONTH") from 8 for 2) as integer)-1) = 0 then (cast(valueof("CURRENT_YEAR") as integer) -1 ) else  (cast(valueof("CURRENT_YEAR") as integer)  ) end) AND ("Gregorian Calendar"."Month Name" =  VALUEOF("PREVIOUS_MONTH_OBIA"))

) UNION (SELECT

   '3. YTD Transfer Outs' saw_0,

   "Department Hierarchy"."SUBLOB Name" saw_1,

   "Basic Information"."Person Number" saw_2,

   1 saw_3

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Deployment Facts"."Employee Headcount" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ("Job"."Job Code" <> 'LTDJBA') AND ("Basic Information"."Person Number"||"Department Hierarchy"."SUBLOB Name" NOT IN

(

SELECT saw_1 FROM (SELECT

   "Gregorian Calendar"."Month Name" saw_0,

   "Basic Information"."Person Number"||"Department Hierarchy"."SubLOB Name" saw_1

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Deployment Facts"."Employee Headcount" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ("Gregorian Calendar"."Month Name" =  VALUEOF("PREVIOUS_MONTH_OBIA"))

) nqw_1

)) AND ("Basic Information"."Person Number"||"Department Hierarchy"."SUBLOB Name" NOT IN

(

SELECT saw_1 FROM (SELECT

   "Gregorian Calendar"."Month Name" saw_0,

   "Basic Information"."Person Number"||"Department Hierarchy"."SubLOB Name" saw_1

FROM "Human Resources - Workforce Deployment"

WHERE

(DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ("Gregorian Calendar"."Month Name" =  VALUEOF("PREVIOUS_MONTH_OBIA")) AND (("Workforce Event Facts"."Employee Voluntary Termination Count" > 0) OR ("Workforce Event Facts"."Employee Involuntary Termination Count" > 0)) AND ("Job"."Job Code" <> 'LTDJBA')

) nqw_1

)) AND (cast(substring("Gregorian Calendar"."Month Name" from 8 for 2) as integer) = 12) AND (cast("Gregorian Calendar"."Year" as integer)  = case when (cast(substring(Valueof("CURRENT_MONTH") from 8 for 2) as integer)-1) = 0 then (cast(valueof("CURRENT_YEAR") as integer) -2 ) else  (cast(valueof("CURRENT_YEAR") as integer) -1 ) end)

) UNION (SELECT

   '5. YTD Transfer Ins' saw_0,

   "Department Hierarchy"."SUBLOB Name" saw_1,

   "Basic Information"."Person Number" saw_2,

   -1 saw_3

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Deployment Facts"."Employee Headcount" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ("Job"."Job Code" <> 'LTDJBA') AND ("Basic Information"."Person Number"||"Department Hierarchy"."SUBLOB Name" NOT IN

(

SELECT saw_1 FROM (SELECT

   "Gregorian Calendar"."Month Name" saw_0,

   "Basic Information"."Person Number"||"Department Hierarchy"."SubLOB Name" saw_1

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Deployment Facts"."Employee Headcount" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND (cast(substring("Gregorian Calendar"."Month Name" from 8 for 2) as integer) = 12) AND (cast("Gregorian Calendar"."Year" as integer)  = case when (cast(substring(Valueof("CURRENT_MONTH") from 8 for 2) as integer)-1) = 0 then (cast(valueof("CURRENT_YEAR") as integer) -2 ) else  (cast(valueof("CURRENT_YEAR") as integer) -1 ) end)

) nqw_1

)) AND ("Basic Information"."Person Number"||"Department Hierarchy"."SUBLOB Name" NOT IN

(

SELECT saw_1 FROM (SELECT

   "Gregorian Calendar"."Month Name" saw_0,

   "Basic Information"."Person Number"||"Department Hierarchy"."SubLOB Name" saw_1

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Event Facts"."Employee Hire Count" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND (cast("Gregorian Calendar"."Year" as integer)  = case when (cast(substring(Valueof("CURRENT_MONTH") from 8 for 2) as integer)-1) = 0 then (cast(valueof("CURRENT_YEAR") as integer) -1 ) else  (cast(valueof("CURRENT_YEAR") as integer)  ) end) AND ("Gregorian Calendar"."Month Name" <=  VALUEOF("PREVIOUS_MONTH_OBIA"))

) nqw_1

)) AND ("Gregorian Calendar"."Month Name" =  VALUEOF("PREVIOUS_MONTH_OBIA"))

) UNION (SELECT

   '6. Prior Month End HC' saw_0,

   "Department Hierarchy"."SUBLOB Name" saw_1,

   "Basic Information"."Person Number" saw_2,

   1 saw_3

FROM "Human Resources - Workforce Deployment"

WHERE

("Workforce Deployment Facts"."Employee Headcount" > 0) AND (DESCRIPTOR_IDOF("Human Resources - Workforce Deployment"."Department Hierarchy"."LOB Name") = '300000015389973') AND ("Pay Grade"."Pay Grade Name" <> 'DEV') AND ("Gregorian Calendar"."Month Name" =  VALUEOF("PREVIOUS_MONTH_OBIA"))

)) t1 ORDER BY saw_0, saw_1, saw_2, saw_3) Massive

GROUP BY saw_0, saw_1 ORDER BY saw_0))  t1 ORDER BY saw_0, saw_1

Marked as Answer by mrmmickle1 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 24 2010
Added on Oct 24 2007
8 comments
96,465 views