Date prompt difference between server environments

building semantic layer
1

Hi,

I have a strange problem, my date prompt differs over 2 environments.
When I fill-in the 04-2014 the DEV server does is correct (‘01-04-2014 00:00:00’) but POC server gives a different date (‘31-03-2014 22:00:00’).

The report and universe are promoted via promotion management.

A nice note, when I use client tools from the DEV server the report is running file on POC. But when I do it through launchpad the SQL makes above mention change.

I checked the oracle.prm file but they matched, and i didnt found any relevent parameters.

Anybody knows what chauses this strange behaviour?

DEV server:


( ( to_date (PERIODEN.MAAND_JAAR,'mm-yyyy') ) between add_months(to_date('01-04-2014 00:00:00', 'DD-MM-YYYY HH24:MI:SS'),-12) and  to_date('01-04-2014 00:00:00','DD-MM-YYYY HH24:MI:SS')  )

POC server:

( ( to_date (PERIODEN.MAAND_JAAR,'mm-yyyy') ) between add_months(to_date('31-03-2014 22:00:00', 'DD-MM-YYYY HH24:MI:SS'),-12) and  to_date('31-03-2014 22:00:00','DD-MM-YYYY HH24:MI:SS')  )

thoraxx (BOB member since 2012-05-03)

2

Check you preferences in Launch Pad are set the same across the two environments.

Mak 1 :uk: (BOB member since 2005-01-06)

3

Checked the Launchpad preferences but they match.

POC environment uses
SAP BusinessObjects BI-platform 4.1 Support Pack 2
Versie: 14.1.2.1121

Dev environment uses
SAP BusinessObjects BI-platform 4.1 Support Pack 3 Patch 2
Versie: 14.1.3.1334

Maybe there was a bug in older BO version?

thoraxx (BOB member since 2012-05-03)

4

There is a bug in SP2:-

https://bobj-board.org/t/214747

:!: Please note you should never run different service packs between BO servers. You are running a risk by doing this.

Mak 1 :uk: (BOB member since 2005-01-06)

5

Thank you for the link!
Looks exactly like my problem.

You are right about the BO versions. Our POC server will be phased out and we are in the process of getting DTAP with same versions :wink:

I will test it when we have the Test server available with the same BO version as Dev.

thoraxx (BOB member since 2012-05-03)