Thursday 21 July 2011

Embedded BI Publisher RD stuck at P

This is the second time (maybe third) that I have seen BI Publisher (BIP) jobs being stuck at P, in terms of the RD.

User Row exit for “View RD jobs” from WSJ and you’ll get a screen like:

image

If jobs are getting stuck at “P” on this screen, this is generally to do with language settings.   A great place to start is https://support.oracle.com and more specifically, https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=661414.1.

This tells you some good info, but missing a key element, what the data should be.  So if you are an English site (and reading this easily), then your row for UDC 01|LP|E should have ‘en’ as the second description.

image

Without this it’s not going to work.  They tell you to look at the pristine data.  All well and good, but I’m going to go one step further and list it her.  Please also ensure that the user that is running these jobs has the correct language code against their profile.

 

DRSY

DRRT

DRKY

DRDL01

DRDL02

01

LP

 

Domestic Language

en

01

LP

1

North America Public Services

 

01

LP

1B

Single Byte Search Description

 

01

LP

AR

Arabic

ar

01

LP

BG

Bulgarian

bg

01

LP

C

Czech

cs

01

LP

CS

Chinese Simplified

zh_CN

01

LP

CT

Chinese Traditional

zh_TW

01

LP

DN

Danish

da

01

LP

DU

Dutch

nl

01

LP

E

English

en

01

LP

F

French

fr

01

LP

FN

Finnish

fi

01

LP

G

German

de

01

LP

GR

Greek

el

01

LP

HR

Croatian

hr

01

LP

HU

Hungarian

hu

01

LP

I

Italian

it

01

LP

J

Japanese

ja

01

LP

KO

Korean

ko

01

LP

NO

Norwegian

no

01

LP

P

Portuguese

pt

01

LP

PO

Polish

pl

01

LP

RO

Romanian

ro

01

LP

RU

Russian

ru

01

LP

S

Spanish

es

01

LP

TR

Turkish

tr

01

LP

W

Swedish

sv

No comments: