When you open a channel, the complete channel balance starts out on the side of the opening party, you. So, by opening two channels, both channels had the complete balance on your side. This leaves no balance on the side of the counterparty to assign to you.
To explain graphically, think of a channel as a string of beads:
A new channel has all the balance on one side:
000------
When you send funds to your channel partner, part of the balance in the channel is assigned to the partner:
00------0
To make a multi-hop payment, you trade balance in your channel for balance in another channel of the counterparty:
000------ | 000------
⇒
00------0 | 00------0
This leaves the same total balance for the forwarding node, just shifted from one channel to another (plus a fee you might have paid for the forwarding).
In your case your two channels looked like this:
000------ | ------000
The forwarding party had no balance in either channel, so it could not facilitate the multi-hop payment. You will need to spend some of your balance, find someone to open a channel to you, purchase in-bound liquidity, or loop-out some balance to generate some in-bound liquidity before you can receive a payment.