Pnr No Slot Is Not Available

-->

This article includes frequently asked questions about deployment issues for Microsoft Azure Cloud Services. You can also consult the Cloud Services VM Size page for size information.

SABRE Passenger Details PNR without a PNR. Ask Question Asked 1 year, 11 months ago. Sounds like the status of the flights you try to book are not 'HK' or 'HL' but UC or so. This means you cant enter the pnr bc. The flight is not available in the predefined booking class. Share improve this answer. Jan 19, 2010  Nickel Pompeii Video slot at Pala Casino. Apologize for the quality of pic and sound. We used our cell which we will never do that again!

If your Azure issue is not addressed in this article, visit the Azure forums on MSDN and Stack Overflow. You can post your issue in these forums, or post to @AzureSupport on Twitter. You also can submit an Azure support request. To submit a support request, on the Azure support page, select Get support.

Why does deploying a cloud service to the staging slot sometimes fail with a resource allocation error if there is already an existing deployment in the production slot?

If a cloud service has a deployment in either slot, the entire cloud service is pinned to a specific cluster. This means that if a deployment already exists in the production slot, a new staging deployment can only be allocated in the same cluster as the production slot.

Allocation failures occur when the cluster where your cloud service is located does not have enough physical compute resources to satisfy your deployment request.

For help with mitigating such allocation failures, see Cloud Service allocation failure: Solutions.

Why does scaling up or scaling out a cloud service deployment sometimes result in allocation failure?

When a cloud service is deployed, it usually gets pinned to a specific cluster. This means scaling up/out an existing cloud service must allocate new instances in the same cluster. If the cluster is nearing capacity or the desired VM size/type is not available, the request may fail.

For help with mitigating such allocation failures, see Cloud Service allocation failure: Solutions.

Why does deploying a cloud service into an affinity group sometimes result in allocation failure?

A new deployment to an empty cloud service can be allocated by the fabric in any cluster in that region, unless the cloud service is pinned to an affinity group. Deployments to the same affinity group will be attempted on the same cluster. If the cluster is nearing capacity, the request may fail.

For help with mitigating such allocation failures, see Cloud Service allocation failure: Solutions.

Why does changing VM size or adding a new VM to an existing cloud service sometimes result in allocation failure?

The clusters in a datacenter may have different configurations of machine types (for example, A series, Av2 series, D series, Dv2 series, G series, H series, etc.). But not all the clusters would necessarily have all the kinds of VMs. For example, if you try to add a D series VM to a cloud service that is already deployed in an A series-only cluster, you will experience an allocation failure. This will also happen if you try to change VM SKU sizes (for example, switching from an A series to a D series).

For help with mitigating such allocation failures, see Cloud Service allocation failure: Solutions.

To check the sizes available in your region, see Microsoft Azure: Products available by region.

Why does deploying a cloud service sometime fail due to limits/quotas/constraints on my subscription or service?

Deployment of a cloud service may fail if the resources that are required to be allocated exceed the default or maximum quota allowed for your service at the region/datacenter level. For more information, see Cloud Services limits.

You could also track the current usage/quota for your subscription at the portal: Azure portal => Subscriptions => <appropriate subscription> => “Usage + quota”.

Resource usage/consumption-related information can also be retrieved via the Azure Billing APIs. See Azure Resource Usage API (Preview).

How can I change the size of a deployed cloud service VM without redeploying it?

You cannot change the VM size of a deployed cloud service without redeploying it. The VM size is built into the CSDEF, which can only be updated with a redeploy.

For more information, see How to update a cloud service.

Why am I not able to deploy Cloud Services through Service Management APIs or PowerShell when using Azure Resource Manager Storage account?

Since the Cloud Service is a Classic resource that is not directly compatible with the Azure Resource Manager model, you can't associate it with the Azure Resource Manager Storage accounts. Here are few options:

  • Deploying through REST API.

    When you deploy through Service Management REST API, you could get around the limitation by specifying a SAS URL to the blob storage, which will work with both Classic and Azure Resource Manager Storage account. Read more about the 'PackageUrl' property here.

  • Deploying through Azure portal.

    This will work from the Azure portal as the call goes through a proxy/shim that allows communication between Azure Resource Manager and Classic resources.

Why does Azure portal require me to provide a storage account for deployment?

In the classic portal, the package was uploaded to the management API layer directly, and then the API layer would temporarily put the package into an internal storage account. This process causes performance and scalability problems because the API layer was not designed to be a file upload service. In the Azure portal (Resource Manager deployment model), we have bypassed the interim step of first uploading to the API layer, resulting in faster and more reliable deployments.

As for the cost, it is very small and you can reuse the same storage account across all deployments. You can use the storage cost calculator to determine the cost to upload the service package (CSPKG), download the CSPKG, then delete the CSPKG.

Background:

I had to upgrade the HANA One (Developer Edition) in AWS from Rev 48 to Rev 56 as part of the openSAP Introduction to Software Development on SAP HANA class.

Rev 48 client setup:

My Win7, C:Windowssystem32driversetchosts file had the entry, aa.bb.cc.dd imdbhdb, where aa.bb.cc.dd is the Elastic IP of the HANA Instance in AWS.

I added the system in HANA studio using the entries below:

Hostname: imdbhdb

Instance Number: 00

DB User Name: SYSTEM

Password: <your password>

Rev 56 Error:

After the upgrade to Rev 56, the above setup resulted in the Error “Database connection is not available” within a few minutes after adding the system in the HANA Studio.

Problem Analysis:

I activated the JDBC trace as below for Rev 56 (See http://help.sap.com/hana_platform SAP HANA Developer’s Guide):

JDBC would initially connect to the HANA server:

user=SYSTEM
reconnect=true
After a few minutes, the JDBC connect string would be replaced by the internal IP of the AWS HANA server and the connection would fail:
user=SYSTEM
timeout=0
validateCertificate=false
HOSTLIST: [10.29.1.187:30015,]
new RTEException: -813 Cannot connect to host 10.29.1.187:30015 [Connection timed out: connect], -813.
at com.sap.db.util.Tracer.whereAmI(Tracer.java:348)
at com.sap.db.rte.comm.RTEException.<init>(RTEException.java:66)
Pnr No Slot Is Not Available
at com.sap.db.rte.comm.SocketComm.openSocket(SocketComm.java:125)
at com.sap.db.rte.comm.SocketComm.<init>(SocketComm.java:58)
at com.sap.db.rte.comm.SocketComm$1.open(SocketComm.java:42)
at com.sap.db.jdbc.topology.Topology.getSession(Topology.java:145)
at com.sap.db.jdbc.Driver.openByURL(Driver.java:1016)
at com.sap.db.jdbc.Driver.connect(Driver.java:230)
at com.sap.ndb.studio.jdbc.JDBCPlugin$3.run(JDBCPlugin.java:642)
=> FAILED

Rev 48 JDBC Connect

Rev 56 JDBC Connect

First three Connection attempts: new Connection ‘jdbc:sap://imdbhdb:30015’

HOSTLIST: [imdbhdb:30015,]

Subsequent Connection attempts:

new Connection ‘jdbc:sap://imdbhdb:30015’

HOSTLIST:

10.30.128.6:30015,]

First three Connection attempts: new Connection ‘jdbc:sap://imdbhdb:30015’ HOSTLIST: [imdbhdb:30015,]

Subsequent Connection attempts:

new Connection ‘jdbc:sap://10.29.1.187:30015’

HOSTLIST: [10.29.1.187:30015,]

I looked at some of the SQL commands in the JDBC trace files:
“SERVICE_NAME”,”ACTIVE_STATUS”,”PROCESS_ID”,

Rev 48 Output

Rev 56 Output

SELECT “HOST”,”KEY”,”VALUE” FROM SYS.M_HOST_INFORMATION WHERE
Slot
UPPER(“HOST”) = ‘IMDBHDB’ AND (UPPER(“KEY”) = ‘SID’ OR UPPER(“KEY”) = ‘SAPSYSTEM’
Pnr No Slot Is Not Available

Rev 48 Output

Rev 56 Output

SELECT “HOST”,”KEY”,”VALUE” FROM SYS.M_HOST_INFORMATION WHERE UPPER(“KEY”) LIKE ‘NET_%’

Rev 48 Output

Rev 56 Output

Workaround:

#1) Someone in openSAP forum suggested using hanaserver in the hosts file entry and in adding the system in HANA studio. While this worked, I did not like this option since hanaserver has no relationship to the actual hostname imdbhdb.

#2) I have been suggesting to folks — in the openSAP forum and in the AWS upgrade blog (http://scn.sap.com/docs/DOC-30980) — to use AWS Elastic IP for hostname in HANA studio while adding the system and to NOT add any entry in the hosts file. While this might be the lesser of the two evils, both options had the yellow-icon problem for the sapstartsrv process in the HANA studio.The SAP HANA Systems (Navigator) tab/view would also say “Some services are not started” (with an yellow icon) or “System state cannot be determined” (with a gray icon) for the system.

Fix:

When you compared the outputs of the SQL commands between Rev 48 and Rev 56 listed above, the only difference is the new key net_publicname added in Rev 56 in the View SYS.M_HOST_INFORMATION.

I had to wait until SPS06 documents were published to see what this new key was.

“Public host name that should be used by client interfaces. Can contain a host name, FQDN or IP address”. (See http://help.sap.com/hana_platform SAP HANA System Views Reference)

The public_hostname_resolution parameter is documented in the SAP HANA Administration Guide (http://help.sap.com/hana_platform). This is a new parameter that has obviously been introduced after Rev 48. The values for this parameter are no,ip,name,fqdn with ip being the default in Rev 56. That is probably why the net_publichostname was set to the internal IP of the AWS HANA Instance. This raises another question as to why this was not set to the public IP (aka AWS Elastic IP) of the AWS Instance. The prudent thing at this point seems to be to disable this feature for the aforementioned reason and for backward compatibility.
Change this parameter value to no (disable feature and use internal hostname) when you are in HANA Studio (configured using the workaround #2 above).

The changed parameters are stored at the OS level as shown below.

The original *.ini files are at the OS level as shown below.

Let us run the SQL command now.

Pnr No Slot Is Not Available Windows 10

SELECT “HOST”,”KEY”,”VALUE” FROM SYS.M_HOST_INFORMATION WHERE UPPER(“KEY”) LIKE ‘NET_%’

Now the net_publicname is set to imdbhdb.

Delete the system from the HANA studio, add the AWS ELASTIC IP-to-host (imdbhdb) mapping in the hosts file, and re-add the system in the HANA studio using the hostname ibmdbhdb.

Now the sapstartsrv process has the green icon as above.

Let us compare the JDBC Connections.

Pnr No Slot Is Not Available 2017

Rev 48 JDBC Connect

Rev 56 JDBC Connect

First three Connection attempts: new Connection ‘jdbc:sap://imdbhdb:30015’ HOSTLIST: [imdbhdb:30015,]

Subsequent Connection attempts:

new Connection ‘jdbc:sap://imdbhdb:30015’HOSTLIST:

sap.com:30015,10.30.128.6:30015,]

First three Connection attempts: new Connection ‘jdbc:sap://imdbhdb:30015’

HOSTLIST: [imdbhdb:30015,]

Subsequent Connection attempts: new Connection ‘jdbc:sap://imdbhdb:30015’

HOSTLIST:

10.29.1.187:30015,]

Pnr No Slot Is Not Available Online

You are done. 🙂

[Please note that I have tested this fix only in AWS. I am not sure if Rev 56 systems hosted by other HANA Cloud hosting providers like CloudShare would have the same issue or if the fix would work if they did.]