Unknown exception: java.lang.NullPointerException Error while trying to login to a new Client

[shiju01]

Hi all,

Not able to login to newly created Client as SuperUser 

Error: Unknown exception: java.lang.NullPointerException

Feb 24, 2018 10:51:35 AM org.compiere.process.SvrProcess unlock

SEVERE: Did not find PInstance 0

Feb 24, 2018 10:51:35 AM org.compiere.model.PO load

SEVERE: NO Data found for AD_Client_ID=1000000

java.lang.Exception

at org.compiere.model.PO.load(PO.java:1348)

at org.compiere.model.PO.load(PO.java:1288)

at org.compiere.model.PO.<init>(PO.java:205)

at org.compiere.model.PO.<init>(PO.java:155)

at org.compiere.model.X_AD_Client.<init>(X_AD_Client.java:38)

at org.compiere.model.MClient.<init>(MClient.java:133)

at org.compiere.model.MClient.<init>(MClient.java:164)

at org.compiere.model.MClient.get(MClient.java:73)

at org.compiere.model.MClient.get(MClient.java:114)

at org.compiere.model.MCountry.loadAllCountries(MCountry.java:118)

at org.compiere.model.MCountry.loadAllCountriesIfNeeded(MCountry.java:107)

at org.compiere.model.MCountry.get(MCountry.java:61)

at org.compiere.model.MLocation.setC_Country_ID(MLocation.java:218)

at org.compiere.model.MLocation.<init>(MLocation.java:178)

at org.compiere.model.MSetup.createEntities(MSetup.java:1147)

at org.adempiere.process.InitialClientSetup.doIt(InitialClientSetup.java:284)

at org.compiere.process.SvrProcess.process(SvrProcess.java:201)

at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:147)

at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:172)

at org.compiere.apps.AbstractProcessCtl.startProcess(AbstractProcessCtl.java:466)

at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:234)

at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:197)

at org.adempiere.webui.apps.AbstractProcessDialog$ProcessDialogRunnable.doRun(AbstractProcessDialog.java:1083)

at org.adempiere.util.ContextRunnable.run(ContextRunnable.java:38)

at org.adempiere.webui.apps.DesktopRunnable.run(DesktopRunnable.java:40)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

 

PO.java

/**

*  (re)Load record with m_ID[*]

*  @param trxName transaction

*  @return true if loaded

*/

public boolean load (String trxName)

{

m_trxName = trxName;

boolean success = true;

StringBuilder sql = new StringBuilder("SELECT ");

int size = get_ColumnCount();

for (int i = 0; i < size; i++)

{

if (i != 0)

sql.append(",");

sql.append(p_info.getColumnSQL(i)); // Normal and Virtual Column

}

sql.append(" FROM ").append(p_info.getTableName())

.append(" WHERE ")

.append(get_WhereClause(false));

//

// int index = -1;

if (log.isLoggable(Level.FINEST)) log.finest(get_WhereClause(true));

PreparedStatement pstmt = null;

ResultSet rs = null;

try

{

pstmt = DB.prepareStatement(sql.toString(), m_trxName); // local trx only

for (int i = 0; i < m_IDs.length; i++)

{

Object oo = m_IDs[i];

if (oo instanceof Integer)

pstmt.setInt(i+1, ((Integer)m_IDs[i]).intValue());

else if (oo instanceof Boolean)

pstmt.setString(i+1, ((Boolean) m_IDs[i] ? "Y" : "N"));

else if (oo instanceof Timestamp)

pstmt.setTimestamp(i+1, (Timestamp)m_IDs[i]);

else

pstmt.setString(i+1, m_IDs[i].toString());

}

rs = pstmt.executeQuery();

if (rs.next())

{

success = load(rs);

}

else

{

log.log(Level.SEVERE, "NO Data found for " + get_WhereClause(true), new Exception());

m_IDs = new Object[] {I_ZERO};

success = false;

// throw new DBException("NO Data found for " + get_WhereClause(true));

}

m_createNew = false;

// reset new values

m_newValues = new Object[size];

}

[shiju01]

Release 5.1

OS: Win32_x86_64

Langauge Setup:

Unchecked Spanish Language - login local and system

Checked English (India) - login local 

Checked English (UK) - login local 

Checked Arabic (Saudi Arabia) - login local 

etc etc

[shiju01]

It got solved after stopping and then restarting the server solved the issue ..possibly some ???

On Saturday, 24 February 2018 11:10:26 UTC+5:30, shiju01 wrote: