We are trying to uninstall a managed package on a sandbox.  It is throwing an error stating that it is used in the codepkg package.  

In Create>Packages there is 1 entry for codepkg that throws the following error when we drill into the name:

Production Package Deleted
This package was deleted in your production organization and is no longer accessible from this sandbox organization. 

Anyone know how to remove this package from the sandbox so that we can go ahead and uninstall the managed package that it is referencing?

We have an issue with a batch apex query that we are running on a full copy sandbox.  We have requested indexes on the fields by logging a case in Salesforce.  Salesforce support keep closing the case without helping to add the required indexes to the object.

Does Salesforce no longer support adding indexes to objects.  The knowledge article says to log a case, yet each time we log a case it gets closed and we are redirected here.


http://help.salesforce.com/apex/HTViewSolution?id=000006227&language=en_US


Here are the details of the case we are trying to log:

We are running a daily bulk API extract using the following query on a full copy sandbox. The query is running for more than 2 hours. Can we have indexes created to help increase the performance:

SELECT Critical_Code_Calc__c FROM Account_Location__c WHERE Critical_Account__c = 'Yes' AND Status__c = 'Active' AND Energy_Type__c = 'ELE' AND RecordTypeId = '012d0000000Wdj2AAC'.

We are currently in UAT phase, so for now we just need the change made to the sandbox "00D110000005k8P".

We are building a java webservice to update records on a sandbox.

We are getting random errors with the connection timing out.  2 out of every 3 connections fail to connect to the sandbox.  When we traced the error we noticed that we are getting the error: java.net.UnknownHostException: cs9.salesforce.com

We are not using a proxy server

This is the error log:

First Attempt Exception:

2014-03-27 07:21:54,072 ERROR [JMS Async S55]                       CSSCustInfoToGF     - Bulk API Connection Exception Occured
com.sforce.ws.ConnectionException: Failed to send request to https://test.salesforce.com/services/Soap/u/30.0/0DFK0000000Cb1t
        at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:129)
        at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.java:1201)

        at com.sforce.soap.partner.PartnerConnection.<init>(PartnerConnection.java:421)
        at com.ngrid.css.CSSCustInfoToGF.getBulkConnection(CSSCustInfoToGF.java:1258)
        at com.ngrid.css.CSSCustInfoToGF.uploadBatchToBulkAPI(CSSCustInfoToGF.java:1105)
        at com.ngrid.css.CSSCustInfoToGF.mapCSSAccountRequest(CSSCustInfoToGF.java:361)
        at com.ngrid.css.CSSCustInfoToGF.onMessage(CSSCustInfoToGF.java:151)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1011)
        at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:175)
        at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2928)
        at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4019)
        at com.sun.ejb.containers.MessageBeanContainer.deliverMessage(MessageBeanContainer.java:1111)
        at com.sun.ejb.containers.MessageBeanListenerImpl.deliverMessage(MessageBeanListenerImpl.java:74)
        at com.sun.enterprise.connectors.inflow.MessageEndpointInvocationHandler.invoke(MessageEndpointInvocationHandler.java:179)
        at com.sun.proxy.$Proxy71.onMessage(Unknown Source)
        at com.stc.jmsjca.core.XMessageEndpoint.onMessage(XMessageEndpoint.java:60)
        at com.stc.jmsjca.core.Delivery.deliverToEndpoint(Delivery.java:1068)
        at com.stc.jmsjca.core.SerialDelivery.onMessage(SerialDelivery.java:253)
        at com.stc.jms.client.SessionImpl.processAsyncDataAvailable(SessionImpl.java:1661)
        at com.stc.jms.client.SessionImpl.processAsync(SessionImpl.java:1750)
        at com.stc.jms.client.SessionImpl.asyncEnter(SessionImpl.java:1778)
        at com.stc.jms.client.SessionImpl.access$500(SessionImpl.java:56)
        at com.stc.jms.client.SessionImpl$1.run(SessionImpl.java:1556)
        at com.stc.jms.client.SessionImpl$2.run(SessionImpl.java:1809)
        at java.lang.Thread.run(Thread.java:761)
Caused by:
java.net.UnknownHostException: test.salesforce.com
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:253)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:376)
        at java.net.Socket.connect(Socket.java:546)
        at com.ibm.jsse2.SSLSocketImpl.connect(SSLSocketImpl.java:11)
        at sun.net.NetworkClient.doConnect(NetworkClient.java:170)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:437)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:551)
        at com.ibm.net.ssl.www2.protocol.https.c.<init>(c.java:116)
        at com.ibm.net.ssl.www2.protocol.https.c.a(c.java:105)
        at com.ibm.net.ssl.www2.protocol.https.d.getNewHttpClient(d.java:12)
        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:978)
        at com.ibm.net.ssl.www2.protocol.https.d.connect(d.java:43)
        at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1043)
        at com.ibm.net.ssl.www2.protocol.https.b.getOutputStream(b.java:71)
        at com.sforce.ws.transport.JdkHttpTransport.connectRaw(JdkHttpTransport.java:115)
        at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:79)
        at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:107)
        ... 28 more

Second Attempt Exception:

2014-03-27 07:52:20,206 ERROR [JMS Async S52]                       CSSCustInfoToGF     - Exception occured while creating the Job |

[AsyncApiException  exceptionCode='ClientInputError'
exceptionMessage='Failed to create job '
]
        at com.sforce.async.BulkConnection.createOrUpdateJob(BulkConnection.java:114)
        at com.sforce.async.BulkConnection.createJob(BulkConnection.java:89)
        at com.ngrid.css.CSSCustInfoToGF.createJob(CSSCustInfoToGF.java:1233)
        at com.ngrid.css.CSSCustInfoToGF.uploadBatchToBulkAPI(CSSCustInfoToGF.java:1106)
        at com.ngrid.css.CSSCustInfoToGF.mapCSSAccountRequest(CSSCustInfoToGF.java:361)
        at com.ngrid.css.CSSCustInfoToGF.onMessage(CSSCustInfoToGF.java:151)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1011)
        at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:175)
        at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2928)
        at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4019)
        at com.sun.ejb.containers.MessageBeanContainer.deliverMessage(MessageBeanContainer.java:1111)
        at com.sun.ejb.containers.MessageBeanListenerImpl.deliverMessage(MessageBeanListenerImpl.java:74)
        at com.sun.enterprise.connectors.inflow.MessageEndpointInvocationHandler.invoke(MessageEndpointInvocationHandler.java:179)
        at com.sun.proxy.$Proxy69.onMessage(Unknown Source)
        at com.stc.jmsjca.core.XMessageEndpoint.onMessage(XMessageEndpoint.java:60)
        at com.stc.jmsjca.core.Delivery.deliverToEndpoint(Delivery.java:1068)
        at com.stc.jmsjca.core.SerialDelivery.onMessage(SerialDelivery.java:253)
        at com.stc.jms.client.SessionImpl.processAsyncDataAvailable(SessionImpl.java:1661)
        at com.stc.jms.client.SessionImpl.processAsync(SessionImpl.java:1750)
        at com.stc.jms.client.SessionImpl.asyncEnter(SessionImpl.java:1778)
        at com.stc.jms.client.SessionImpl.access$500(SessionImpl.java:56)
        at com.stc.jms.client.SessionImpl$1.run(SessionImpl.java:1556)
        at com.stc.jms.client.SessionImpl$2.run(SessionImpl.java:1809)
        at java.lang.Thread.run(Thread.java:761)
Caused by:
java.net.UnknownHostException: cs9.salesforce.com
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:253)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:376)
        at java.net.Socket.connect(Socket.java:546)
        at com.ibm.jsse2.SSLSocketImpl.connect(SSLSocketImpl.java:11)
        at com.ibm.jsse2.dd.connect(dd.java:83)
        at sun.net.NetworkClient.doConnect(NetworkClient.java:175)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:437)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:551)
        at com.ibm.net.ssl.www2.protocol.https.c.<init>(c.java:116)
        at com.ibm.net.ssl.www2.protocol.https.c.a(c.java:105)
        at com.ibm.net.ssl.www2.protocol.https.d.getNewHttpClient(d.java:12)
        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:978)
        at com.ibm.net.ssl.www2.protocol.https.d.connect(d.java:43)
        at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1043)
        at com.ibm.net.ssl.www2.protocol.https.b.getOutputStream(b.java:71)
        at com.sforce.ws.transport.JdkHttpTransport.connectRaw(JdkHttpTransport.java:115)
        at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:79)
        at com.sforce.async.BulkConnection.createOrUpdateJob(BulkConnection.java:95)
        ... 27 more

This is the connection code:

private BulkConnection getBulkConnection(String userName, String password)
            throws ConnectionException, AsyncApiException {
        asyncErrorMsg = "Exception occured while establishing the connection";
        ConnectorConfig partnerConfig = new ConnectorConfig();

        partnerConfig.setUsername(userName);
        partnerConfig.setPassword(password);
        partnerConfig.setConnectionTimeout(Integer.parseInt(System.getProperty("ConnectionTimeOut")));

        partnerConfig.setAuthEndpoint(System.getProperty("GFEndPoint"));
        // Creating the connection automatically handles login and stores
        // the session in partnerConfig
        new PartnerConnection(partnerConfig);
        // When PartnerConnection is instantiated, a login is implicitly
        // executed and, if successful,
        // a valid session is stored in the ConnectorConfig instance.
        // Use this key to initialize a BulkConnection:
        ConnectorConfig config = new ConnectorConfig();
        config.setSessionId(partnerConfig.getSessionId());
        // The endpoint for the Bulk API service is the same as for the normal
        // SOAP uri until the /Soap/ part. From here it's '/async/versionNumber'
        String soapEndpoint = partnerConfig.getServiceEndpoint();
        String apiVersion = "30.0";
        String restEndpoint = soapEndpoint.substring(0, soapEndpoint.indexOf("Soap/")) + "async/" + apiVersion;
        config.setRestEndpoint(restEndpoint);
        // This should only be false when doing debugging.
        config.setCompression(true);
        // Set this to true to see HTTP requests and responses on stdout
        config.setTraceMessage(false);
        BulkConnection connection = new BulkConnection(config);
        return connection;
    }

We are building a java webservice to update records on a sandbox.

We are getting random errors with the connection timing out.  2 out of every 3 connections fail to connect to the sandbox.  When we traced the error we noticed that we are getting the error: java.net.UnknownHostException: cs9.salesforce.com

We are not using a proxy server

This is the error log:

First Attempt Exception:

2014-03-27 07:21:54,072 ERROR [JMS Async S55]                       CSSCustInfoToGF     - Bulk API Connection Exception Occured
com.sforce.ws.ConnectionException: Failed to send request to https://test.salesforce.com/services/Soap/u/30.0/0DFK0000000Cb1t
        at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:129)
        at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.java:1201)

        at com.sforce.soap.partner.PartnerConnection.<init>(PartnerConnection.java:421)
        at com.ngrid.css.CSSCustInfoToGF.getBulkConnection(CSSCustInfoToGF.java:1258)
        at com.ngrid.css.CSSCustInfoToGF.uploadBatchToBulkAPI(CSSCustInfoToGF.java:1105)
        at com.ngrid.css.CSSCustInfoToGF.mapCSSAccountRequest(CSSCustInfoToGF.java:361)
        at com.ngrid.css.CSSCustInfoToGF.onMessage(CSSCustInfoToGF.java:151)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1011)
        at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:175)
        at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2928)
        at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4019)
        at com.sun.ejb.containers.MessageBeanContainer.deliverMessage(MessageBeanContainer.java:1111)
        at com.sun.ejb.containers.MessageBeanListenerImpl.deliverMessage(MessageBeanListenerImpl.java:74)
        at com.sun.enterprise.connectors.inflow.MessageEndpointInvocationHandler.invoke(MessageEndpointInvocationHandler.java:179)
        at com.sun.proxy.$Proxy71.onMessage(Unknown Source)
        at com.stc.jmsjca.core.XMessageEndpoint.onMessage(XMessageEndpoint.java:60)
        at com.stc.jmsjca.core.Delivery.deliverToEndpoint(Delivery.java:1068)
        at com.stc.jmsjca.core.SerialDelivery.onMessage(SerialDelivery.java:253)
        at com.stc.jms.client.SessionImpl.processAsyncDataAvailable(SessionImpl.java:1661)
        at com.stc.jms.client.SessionImpl.processAsync(SessionImpl.java:1750)
        at com.stc.jms.client.SessionImpl.asyncEnter(SessionImpl.java:1778)
        at com.stc.jms.client.SessionImpl.access$500(SessionImpl.java:56)
        at com.stc.jms.client.SessionImpl$1.run(SessionImpl.java:1556)
        at com.stc.jms.client.SessionImpl$2.run(SessionImpl.java:1809)
        at java.lang.Thread.run(Thread.java:761)
Caused by:
java.net.UnknownHostException: test.salesforce.com
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:253)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:376)
        at java.net.Socket.connect(Socket.java:546)
        at com.ibm.jsse2.SSLSocketImpl.connect(SSLSocketImpl.java:11)
        at sun.net.NetworkClient.doConnect(NetworkClient.java:170)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:437)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:551)
        at com.ibm.net.ssl.www2.protocol.https.c.<init>(c.java:116)
        at com.ibm.net.ssl.www2.protocol.https.c.a(c.java:105)
        at com.ibm.net.ssl.www2.protocol.https.d.getNewHttpClient(d.java:12)
        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:978)
        at com.ibm.net.ssl.www2.protocol.https.d.connect(d.java:43)
        at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1043)
        at com.ibm.net.ssl.www2.protocol.https.b.getOutputStream(b.java:71)
        at com.sforce.ws.transport.JdkHttpTransport.connectRaw(JdkHttpTransport.java:115)
        at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:79)
        at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:107)
        ... 28 more

Second Attempt Exception:

2014-03-27 07:52:20,206 ERROR [JMS Async S52]                       CSSCustInfoToGF     - Exception occured while creating the Job |

[AsyncApiException  exceptionCode='ClientInputError'
exceptionMessage='Failed to create job '
]
        at com.sforce.async.BulkConnection.createOrUpdateJob(BulkConnection.java:114)
        at com.sforce.async.BulkConnection.createJob(BulkConnection.java:89)
        at com.ngrid.css.CSSCustInfoToGF.createJob(CSSCustInfoToGF.java:1233)
        at com.ngrid.css.CSSCustInfoToGF.uploadBatchToBulkAPI(CSSCustInfoToGF.java:1106)
        at com.ngrid.css.CSSCustInfoToGF.mapCSSAccountRequest(CSSCustInfoToGF.java:361)
        at com.ngrid.css.CSSCustInfoToGF.onMessage(CSSCustInfoToGF.java:151)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1011)
        at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:175)
        at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2928)
        at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4019)
        at com.sun.ejb.containers.MessageBeanContainer.deliverMessage(MessageBeanContainer.java:1111)
        at com.sun.ejb.containers.MessageBeanListenerImpl.deliverMessage(MessageBeanListenerImpl.java:74)
        at com.sun.enterprise.connectors.inflow.MessageEndpointInvocationHandler.invoke(MessageEndpointInvocationHandler.java:179)
        at com.sun.proxy.$Proxy69.onMessage(Unknown Source)
        at com.stc.jmsjca.core.XMessageEndpoint.onMessage(XMessageEndpoint.java:60)
        at com.stc.jmsjca.core.Delivery.deliverToEndpoint(Delivery.java:1068)
        at com.stc.jmsjca.core.SerialDelivery.onMessage(SerialDelivery.java:253)
        at com.stc.jms.client.SessionImpl.processAsyncDataAvailable(SessionImpl.java:1661)
        at com.stc.jms.client.SessionImpl.processAsync(SessionImpl.java:1750)
        at com.stc.jms.client.SessionImpl.asyncEnter(SessionImpl.java:1778)
        at com.stc.jms.client.SessionImpl.access$500(SessionImpl.java:56)
        at com.stc.jms.client.SessionImpl$1.run(SessionImpl.java:1556)
        at com.stc.jms.client.SessionImpl$2.run(SessionImpl.java:1809)
        at java.lang.Thread.run(Thread.java:761)
Caused by:
java.net.UnknownHostException: cs9.salesforce.com
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:253)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:376)
        at java.net.Socket.connect(Socket.java:546)
        at com.ibm.jsse2.SSLSocketImpl.connect(SSLSocketImpl.java:11)
        at com.ibm.jsse2.dd.connect(dd.java:83)
        at sun.net.NetworkClient.doConnect(NetworkClient.java:175)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:437)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:551)
        at com.ibm.net.ssl.www2.protocol.https.c.<init>(c.java:116)
        at com.ibm.net.ssl.www2.protocol.https.c.a(c.java:105)
        at com.ibm.net.ssl.www2.protocol.https.d.getNewHttpClient(d.java:12)
        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:978)
        at com.ibm.net.ssl.www2.protocol.https.d.connect(d.java:43)
        at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1043)
        at com.ibm.net.ssl.www2.protocol.https.b.getOutputStream(b.java:71)
        at com.sforce.ws.transport.JdkHttpTransport.connectRaw(JdkHttpTransport.java:115)
        at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:79)
        at com.sforce.async.BulkConnection.createOrUpdateJob(BulkConnection.java:95)
        ... 27 more

This is the connection code:

private BulkConnection getBulkConnection(String userName, String password)
            throws ConnectionException, AsyncApiException {
        asyncErrorMsg = "Exception occured while establishing the connection";
        ConnectorConfig partnerConfig = new ConnectorConfig();

        partnerConfig.setUsername(userName);
        partnerConfig.setPassword(password);
        partnerConfig.setConnectionTimeout(Integer.parseInt(System.getProperty("ConnectionTimeOut")));

        partnerConfig.setAuthEndpoint(System.getProperty("GFEndPoint"));
        // Creating the connection automatically handles login and stores
        // the session in partnerConfig
        new PartnerConnection(partnerConfig);
        // When PartnerConnection is instantiated, a login is implicitly
        // executed and, if successful,
        // a valid session is stored in the ConnectorConfig instance.
        // Use this key to initialize a BulkConnection:
        ConnectorConfig config = new ConnectorConfig();
        config.setSessionId(partnerConfig.getSessionId());
        // The endpoint for the Bulk API service is the same as for the normal
        // SOAP uri until the /Soap/ part. From here it's '/async/versionNumber'
        String soapEndpoint = partnerConfig.getServiceEndpoint();
        String apiVersion = "30.0";
        String restEndpoint = soapEndpoint.substring(0, soapEndpoint.indexOf("Soap/")) + "async/" + apiVersion;
        config.setRestEndpoint(restEndpoint);
        // This should only be false when doing debugging.
        config.setCompression(true);
        // Set this to true to see HTTP requests and responses on stdout
        config.setTraceMessage(false);
        BulkConnection connection = new BulkConnection(config);
        return connection;
    }

 We are trying to uninstall a managed package on a sandbox.  It is throwing an error stating that it is used in the codepkg package.  

In Create>Packages there is 1 entry for codepkg that throws the following error when we drill into the name:

Production Package Deleted
This package was deleted in your production organization and is no longer accessible from this sandbox organization. 

Anyone know how to remove this package from the sandbox so that we can go ahead and uninstall the managed package that it is referencing?